Hi all,
I have created a workbook that has a before save macro and
It works perfectly. Until i discover that users are entering the design
Mode then making changes on the cell and click save while on design
Mode.
My problem is they are able to bypass my vba code when they save
The workbook while in the design mode because the vba code will not
Execute in this mode,
Is there any way to solve this problem? Thanks in advance for all the response
You might try this oct2mine:
"lock project for viewing"
under tools|VBAProject Propertiesl protection
Check the box to lock project.
Enter password, save the file, close it, and reopen.
Next time someone tries to view code, they'll face a password prompt, and no visible vba code..
To remove vba protection, reverse the steps, and uncheck the box, remove your password from both password fields. save the file, and close.
Pete
Last edited by PeteABC123; 03-13-2015 at 11:24 AM. Reason: added details
Hi peteABC123,
Ive already tried that but it only prevent user on viewing the vba codes. What i
Exactly need is to disable the design mode to prevent users going to the design
Mode of the worksheet because once they enable the design mode, all my vba codes
Are not working and they are free to do whatever they want in the worksheet cells. Hope someone could help me regarding this. Thanks pete for your response
Perhaps something like
Alf
Please Login or Register to view this content.
I have tried this but it doesnt work at all. someone how know how to solve this problem please
I'll have a last go at this problem then I'm out of ideas
AlfPlease Login or Register to view this content.
you can use customUI to display DesignMode
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" >
<commands >
<command
enabled="false"
idMso="DesignMode"/>
</commands >
</customUI >
Hello,
Your excel atteched file it's the solution that i want.
What code do you put on file 1071932.xlsm or how/where can i put it? Can you help?
many thanks
Hello
Search for Office Custom UI Editor >> download and install >> Open it and using Open command to select the file of Andy and you will see the code
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
First thanks a lot, I had / have the same problem.
Indeed the problem remains open because the user can get the same effect by pressing Alt + F11 and then the pause button (it works even if the VBA is protected).
Please, can you tell me if it is possible to act in the same way as above also for the keys of the development environment?
If it is possible what is the relevant idMso?
Thanks in advance.
Last edited by tomluigi; 09-24-2019 at 06:29 AM. Reason: typing blunder
Administrative Note:Originally Posted by tomluigi
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks