| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro protection
I have a worksheet that is protected, it has a macro that
applies to the worksheet. Problem is that if someone edits the macro it contains the password for the worksheet protection. Is there any way to protect or hide the macro so they cannot see the password? Leigh |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro protection
Hi
one way (though it can easily be overcome'): - in the VBA editor right-click on your project name - choose 'Properties - Protection' - choose a password -- Regards Frank Kabel Frankfurt, Germany leigh wrote: I have a worksheet that is protected, it has a macro that applies to the worksheet. Problem is that if someone edits the macro it contains the password for the worksheet protection. Is there any way to protect or hide the macro so they cannot see the password? Leigh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
| macro protection | Excel Discussion (Misc queries) | |||
| Macro Protection | New Users to Excel | |||
| macro for protection | Excel Discussion (Misc queries) | |||
| protection macro | Excel Programming | |||
Hybrid Mode
