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" <Keisamcasco@discussions.microsoft.com> wrote in message
news:12E280B5-02DB-4F77-AD51-59EC0D9774C9@microsoft.com...
>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" <Keisamcasco@discussions.microsoft.com> wrote in message
> news:12E280B5-02DB-4F77-AD51-59EC0D9774C9@microsoft.com...
> >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 <9874EFEB-3172-4F9F-BB97-8CA2C965AE74@microsoft.com>,
"Keisamcasco" <Keisamcasco@discussions.microsoft.com> wrote:

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