R
Robin Hammond
Using Word XP I have a document with lots of code. I can add a menu item on
the fly when the document opens using the Document_Open event. However, the
macro this calls only appears to be available to the document, and cannot be
called from another.
So first, question, is there a way to specify the document name in the
OnAction property for a commandbarbutton such that the routines in my
document are available to all open documents.
Second issue is that if I save the document as a template, when I open the
template directly using File Open the document open macro event does not
fire so I get no menu item added.
Third issue, if I load the file using Templates and Add-ins, then switch to
the VB Editor, the project is unviewable, even though there was no
protection set before I saved it. Again, the document open event does not
fire.
I'm an Excel man really, so this has me confused. Any help on these would be
much appreciated.
Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in
the fly when the document opens using the Document_Open event. However, the
macro this calls only appears to be available to the document, and cannot be
called from another.
So first, question, is there a way to specify the document name in the
OnAction property for a commandbarbutton such that the routines in my
document are available to all open documents.
Second issue is that if I save the document as a template, when I open the
template directly using File Open the document open macro event does not
fire so I get no menu item added.
Third issue, if I load the file using Templates and Add-ins, then switch to
the VB Editor, the project is unviewable, even though there was no
protection set before I saved it. Again, the document open event does not
fire.
I'm an Excel man really, so this has me confused. Any help on these would be
much appreciated.
Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in