Quote:
|
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?
|
No.
Quote:
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 do not understand what you mean by "above restrictions". WHAT restrictions? Again, once Document_Open fires ANY code in Document_Open has full access to VBA.
You are talking about two separate things. Manually amending code with the VBE (viia Alt-F11) is one thing. Executing code in Document_Open is something else.
Perhaps if you tried to explain what you are doing. Why are you amending code?