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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
> news:[email protected]...
> >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 <[email protected]>,
"Keisamcasco" <[email protected]> wrote:

> I did it and it worked. MUCH THANKS !!