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 ?

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 ?

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 ?

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 !!