Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Routing Recipient function killing my macros....

Status
Not open for further replies.

sera

Technical User
Jun 29, 2000
360
US
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
 
Actually I can manually run the AutoOpen() function but it will not set the keybindings, but does not error!?

I need to have a key shortcut for people to run this macro during the Routing process.

Thanks

Sera
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top