Missing macro that is there and not there

[ronben]

Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel This is revisiting a chronic problem (taken up previously on this forum). The drop down list of macros (under declarations) lists a macro which, however, when I want to insert it into an Exit from a form field, is not listed, despite 'All active templates and documents'. It was not saved as private. So, its there but its not there; I can't get it into the form field. Whats going on here?
Thanks,
Ron

 

[Jim Gordon Mac MVP]

Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel
This is revisiting a chronic problem (taken up previously on this
forum). The drop down list of macros (under declarations) lists a macro
which, however, when I want to insert it into an Exit from a form field,
is not listed, despite 'All active templates and documents'. It was not
saved as private. So, its there but its not there; I can't get it into
the form field. Whats going on here?
Thanks,
Ron

Hi Ron,

When you are viewing a regular worksheet use Tools > Macro > Macros for
a list of all Macros. Is it there? If so, then click Edit to view and
edit or copy the macro.

-Jim

 

[John McGhie]

Hi Ron:

Sounds like a context problem to me:

The macro you want to insert, and the form, must be in the same module in
the same project; or you must create a stub in the current module that
"Calls" the macro explicitly (using the "Call" or "Run" command).

Cheers

Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel This is
revisiting a chronic problem (taken up previously on this forum). The drop
down list of macros (under declarations) lists a macro which, however, when I
want to insert it into an Exit from a form field, is not listed, despite 'All
active templates and documents'. It was not saved as private. So, its there
but its not there; I can't get it into the form field. Whats going on here?
Thanks,
Ron

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

--

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:[email protected]

 

[ronben]

Jim,
The macro is listed under Declarations but is not in the dropdown list for calling it upon exit from the form field.

John,
The only way I could work around this was to copy the code, delete references to the macro by that name, create a macro with a different name, and paste the code.

You are probably right; I may have been in the wrong Project, but I have yet to fully understand that window.

Thanks,
Ron