How do I protect a macro to prevent change ?

G

Guest

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 ?
 
O

OZDOC1050

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
 
G

Guest

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

OZDOC1050 said:
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 said:
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 ?
Click to expand...
Click to expand...
 
J

JE McGimpsey

Note that it takes about 30 seconds to bypass this protection, if you
know how, or if you use relatively inexpensive commercial options.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to protect macro cointained Worksheets and workbooks by using 6
Delete macro that is not in a module 5
How to protect coping of excel file? 3
Protect and Unprotect all worksheets with macro 2
MACRO SECURITY 2
problem with macros and protections 5
how to prevent macros in Personal.xls appearing in other workbook 3
permissions for running macros 5

Top