Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unprotecting Sheets with VBA and IRM
I have a Excel template with VBA code that I am trying to distribute.
I want to use the IRM in Office 2003 and have given the users "Change" rights to the sheet. However, the macro will crash when it attempts to unprotect the sheet. If I look further, the Unprotect option under Tools/Protection is greyed out. Changing the access and providing the user "Full" access will solve this but effectively defeat the purpose of enableling IRM in the first place! Any workarounds? Philip |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unprotecting Sheets | New Users to Excel | |||
Protecting & Unprotecting Sheets | Excel Programming | |||
PROTECTING/UNPROTECTING SHEETS | Excel Discussion (Misc queries) | |||
unprotecting sheets | Excel Programming | |||
Protecting and Unprotecting multiple sheets | Excel Programming |