I have a series of forms arranged as pop-up 'Help' forms which can be called from different parts of my application. Each Help form has a hyperlink (text 'Close') linked to a macro containing a close form action . (I think this looks nicer than a normal button)This works if I have a separate macro for each form e.g. frmHelp1 has a Close hyperlink which runs mcrCloseHelp1, frmHelp2 has a Close hyperlink which runs mcrCloseHelp2 etc.
Now I wish to tidy this up by putting all the the close form actions in one macro with sub macros, i.e. mcrCloseHelp.CloseHelp1[CloseHelp2][CloseHelp3] etc. But the hyperlink does not seem to recognize submacros.
So the hyperlink will work like this:
Hyperlink Address: Macro mcrCloseHelp1
but not like this:
Hyperlink Address: Macro mcrCloseHelp.CloseHelp1
It errors first with a security warning, then an error message:
'Unable to open Macro mcrCloseHelp.CloseHelp1. Cannot open the file.'
Can anyone help or should I just save myself the effort and put a Close button on the form?