OK, I'm not sure if anyone has seen this before.... but I'll try and explain my problem.
I have a WORD doc with some custom macros. These macros are password protected. I have assigned key shortcuts and added a menu button to launch the macro. I have a AutoOpen() macro that I need to run when the doc is opened.
If I send this file as an attachment (via Outlook) everything is fine. All the macros run ok.
If I use the Routing Slip functions (which I NEED to use). The macros are hosed. The keyboard shortcut doesn't exist. The menu button is gone. The AutoOpen() function doesn't run.
I can open the macro editor, put in my password, and run most of the macros. But even if I manually run the AutoRun() it doesn't run. I don't see my msgbox("got here").
I wrote this document and macro set about 4 months ago. When I tested it then everything worked fine. Now they are hosed. Patch maybe?
BTW. I have a similar macro set in an Excel file and the Routing doesn't bother it at all!!!!
Can anyone shed some light on this problem...
PS.
I thought it might just need to have the keybindings set in the AutoOpen()... so I made it do this programmatically, but after you Route the doc it dosent run the AutoOpen. I have tried unpasswording it. I have tried Save As. so it isn't in the Outlook temp files. I have tried everything I can think of.
Sera
I have a WORD doc with some custom macros. These macros are password protected. I have assigned key shortcuts and added a menu button to launch the macro. I have a AutoOpen() macro that I need to run when the doc is opened.
If I send this file as an attachment (via Outlook) everything is fine. All the macros run ok.
If I use the Routing Slip functions (which I NEED to use). The macros are hosed. The keyboard shortcut doesn't exist. The menu button is gone. The AutoOpen() function doesn't run.
I can open the macro editor, put in my password, and run most of the macros. But even if I manually run the AutoRun() it doesn't run. I don't see my msgbox("got here").
I wrote this document and macro set about 4 months ago. When I tested it then everything worked fine. Now they are hosed. Patch maybe?
BTW. I have a similar macro set in an Excel file and the Routing doesn't bother it at all!!!!
Can anyone shed some light on this problem...
PS.
I thought it might just need to have the keybindings set in the AutoOpen()... so I made it do this programmatically, but after you Route the doc it dosent run the AutoOpen. I have tried unpasswording it. I have tried Save As. so it isn't in the Outlook temp files. I have tried everything I can think of.
Sera