View Single Post
 
Old 04-23-2014, 01:59 AM
Sorcerer13 Sorcerer13 is offline Windows Vista Office 2010 32bit
Novice
 
Join Date: Sep 2012
Location: God's Own County
Posts: 16
Sorcerer13 is on a distinguished road
Default Further details....

Thanks Fumei....

As I suspected, the same process seems to be fired by DC or RMC+Open.

So I'll rephrase the original question: When in Document_Open, can I look at some system variable to determine what method was used to open the document?

I strongly suspect the answer is "No".

As to the next bit, I currently have VBA in Document_Open which immediately shows an Userform etc. So from then on, processing is restricted to options offered to the User.
To amend/update the code, I normally access the document's VBA by opening the document, then use Alt+F11, but the above restrictions mean that option is no longer available to me.
Therefore, at the moment in Document_Open I detect the current User's name, then, for selected Users (me!), I offer the option of normal processing or VBA access.

I was just musing on the idea of simplifying this process....
Reply With Quote