| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect then reprotect using macro
This is so frustrating. When you password protect your sheet you can filter
if you tick ALL the options but you can't use the ShowAll feature. Does any one know how to unprotect sheet then select ShowAll then re protect? When I attempt to do it then run the macro it keeps asking for a password. I don't want users to have to use a password. I would like the macro to type the password instead. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect macro from stopping | Excel Discussion (Misc queries) | |||
| Protect sheet in macro | Excel Worksheet Functions | |||
| Protect macro | Excel Discussion (Misc queries) | |||
| Using macro to un/protect sheet | Excel Worksheet Functions | |||
| How to protect my macro | Excel Discussion (Misc queries) | |||
Threaded Mode
