Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I protect a macro to prevent change ?
I have protection turned on for both the worksheets and the workbook. Even
so, the user can open Visual Basic Editor and change the macros. How to I protect the macros from being changed ? |
#2
|
|||
|
|||
In Visual Basic go to tools vga project properties protection
and you will see a section for pass words Try to keep the same pass for all of your work to make things easy if you need to get back in. cheers Pete -- (][ THIS EMAIL HAS BEEN SCANNED BY NORTON ANTIVIRUS ][) "Keisamcasco" wrote in message ... I have protection turned on for both the worksheets and the workbook. Even so, the user can open Visual Basic Editor and change the macros. How to I protect the macros from being changed ? |
#3
|
|||
|
|||
I did it and it worked. MUCH THANKS !!
Nick "OZDOC1050" wrote: In Visual Basic go to tools vga project properties protection and you will see a section for pass words Try to keep the same pass for all of your work to make things easy if you need to get back in. cheers Pete -- (][ THIS EMAIL HAS BEEN SCANNED BY NORTON ANTIVIRUS ][) "Keisamcasco" wrote in message ... I have protection turned on for both the worksheets and the workbook. Even so, the user can open Visual Basic Editor and change the macros. How to I protect the macros from being changed ? |
#4
|
|||
|
|||
Note that it takes about 30 seconds to bypass this protection, if you
know how, or if you use relatively inexpensive commercial options. In article , "Keisamcasco" wrote: I did it and it worked. MUCH THANKS !! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
macro color change | Excel Worksheet Functions | |||
How to protect my macro | Excel Discussion (Misc queries) | |||
Macro button colour change??? | Excel Worksheet Functions |