Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting Macro's
Hello people,
Just a quick question for you. Is it possible to prevent a macro from being altered in a worksheet? I know you can protect teh worksheet with a password etc but can the macro's within it be protected as well? Any help gratefully recieved Cheers Nick |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting Macro's
Macros are viewed in the Visual Basic Editor
Press Alt+F11 to get it. Click on Tools, VBAProject Properties, Protection Check the checkbox "Lock Project for Viewing" and type in a password. -----Original Message----- Hello people, Just a quick question for you. Is it possible to prevent a macro from being altered in a worksheet? I know you can protect teh worksheet with a password etc but can the macro's within it be protected as well? Any help gratefully recieved Cheers Nick . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Macro's in Toolbar / Macro's list | Excel Discussion (Misc queries) | |||
Protecting Macro's | Excel Worksheet Functions | |||
Protecting Macro's | Excel Worksheet Functions | |||
Protecting Macro's | Excel Programming | |||
Protecting Macro's | Excel Programming |