Quote:
|
If, in Document_Open the VBA takes control of the User's options and does not allow the User the option of entering the VB Editor,
|
Sorry, I thought by mentioning the users - and in fact bolding it! - it had something to do with users. But it has nothing to do with users now does it. You apparently call a userform from Document_Open which stops all access anyway. Including you.
I did read your posts carefully. you should do the same for me.
Quote:
|
In Document_Open I take complete control, and never allow the User the option to do anything except make entries on Userforms.
|
If Document_open Shows (opens) a userform, then it has focus. YOU have nothing to do with it. YOU are not ensuring the user has no access to the VBE. With the userform having focus, nobody (including you) have access.
I have developed hundreds (literally) of templates and documents using userforms in a corporate environment. Sorry you are miffed. I was trying to help. But...OK...I will leave you to it then.