Replies

Does this also mean that you can only have 1 “Function name” per module ??
(so that a module in fact is equivalent to the “Function name” frame ??)

Does this also mean that you can only have 1 “Function name” per module ??
(so that a module in fact is equivalent to the “Function name” frame ??)

What about the “Refers to” line – what does this do in this respect ??
– has it any function at all or is its functionality “non-existing” in this connection.

What about the “Refers to” line – what does this do in this respect ??
– has it any function at all or is its functionality “non-existing” in this connection.

Tried to follow the knowledge base article, but it’s not quite clear to me, how I get the connection between the XL 4.0 macro and the VBA module.
Eventhough scope of functions are public, they are not visible in the frame.

Could you please be very detailed how this works ??

Further is it possible somehow to add a decription to the function ?
Equivalent to what is shown just under the “Function Category” frame

Tried to follow the knowledge base article, but it’s not quite clear to me, how I get the connection between the XL 4.0 macro and the VBA module.
Eventhough scope of functions are public, they are not visible in the frame.

Could you please be very detailed how this works ??

Further is it possible somehow to add a decription to the function ?
Equivalent to what is shown just under the “Function Category” frame

Thanks – looks promising, though my memory on XL macros has faded substantially… odd thing to have it only this way….??

Do the functions have to be done on the macro sheet or can I still do them in module under VBA ??

Thanks – looks promising, though my memory on XL macros has faded substantially… odd thing to have it only this way….??

Do the functions have to be done on the macro sheet or can I still do them in module under VBA ??

I’m afraid not. It’s not that it can’t see the macro – it’s simply misunderstanding the setting.

When I enter “TOOLS|MACRO|Security” option button “Low” is selected – thus I should not receive the DISABLE – ENABLE – CANCEL dialog question.
– but I do…., subsequently eventhough I answer “enable”, the macros cannot be run (informed by a dialog “due to your macro security settings”)

… and this is where I start getting really frustrated as I can’t find a workaround….

Subsequently I shut down Word restart it with the exact same settings – eh Voil

Hi Hans,

An additional question/comment.
If I’ve understood it correctly templates loaded as global templates (potentially added through code as they become needed) also make their macros available, eventhough they are not the “attached template” – isn’t this correct ?

I’m using this method to keep down the complexity and size of my templates.
Keeping styles and minor autotext formatting issues in “the master” and all additional code in templates that load/unload as they become needed…
– if the functions become general enough they can subsequently be turned into .dll’s

Henrik

Hi Hans,

An additional question/comment.
If I’ve understood it correctly templates loaded as global templates (potentially added through code as they become needed) also make their macros available, eventhough they are not the “attached template” – isn’t this correct ?

I’m using this method to keep down the complexity and size of my templates.
Keeping styles and minor autotext formatting issues in “the master” and all additional code in templates that load/unload as they become needed…
– if the functions become general enough they can subsequently be turned into .dll’s

Henrik

I had noted exactly that and thought the logical extension would be modName and ProcName
– but I couldn’t find these so apparently MS thought otherwise, my second hope was then that some of you clever guys out there had made some sort of a tweak for this…

Thanks anyway

Thanks Hans,

Feared you would say this…
Having to add it as separate code does take a bit of the flexibility out of it. (Then I have to code modName and ProcedureName anyway – somewhere…)

What I had hoped for was to be able to do something like Err.Number & “:” & Err.Description & ” (” & Err.modName & “;” & Err.ProcName & “)”
– but apparently this is not a way forward – pitty though.

;o)) Henrik

Right, no I didn’t mention my monitor, as I initially didn’t have that in mind – all my other apps are working fine….

Check mark was in “Center dialog boxes on screen” – and apparently the Matrox driver don’t distinguish between run and design modes for forms…
– so the screen tri-angulated its edges and placed top left of my forms in center of the screen… (@#$!% !!! – well, guess I asked for it… (an “error 40”))

Thanks for all efforts anyway.

;o)) Henrik

Yupi-ka-ye…

MYSTERY SOLVED !! (apologies for yelling, but this was a mean one)

Matrox has for ao. dual screens a utility called “Powerdesk”, this was the one that caused all the fuzz.

Thanks for all efforts put in.