![]() |
|
#3
|
|||
|
|||
|
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.... |
| Tags |
| document options, document properties, vba script |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
How do you identify the ID of a picture in PowerPoint?
|
CatMan | PowerPoint | 4 | 04-17-2012 03:29 PM |
| How to identify whether Word 2007 was used to create a document saved as Word 2003 | noviceatwork | Word | 0 | 03-08-2012 06:40 AM |
identify non-members from two lists
|
rterrain03 | Office | 5 | 12-01-2011 01:41 PM |
| how to identify the word files created using Windows or Mac Operating System? | mariaprabudass | Word | 0 | 08-06-2010 05:52 AM |
| C# API to identify the uncommitted changes in Excel and Word document? | althafuddeen | Excel | 0 | 04-06-2010 07:40 AM |