| 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 | |||
Hybrid Mode
