Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection Macros--modify to allow format changes
Hello. I am currently using the following macro:
Option Explicit Sub UnprotectAll() dim wks as worksheet for each wks in activeworkbook.worksheets wks.unprotect password:="topsecret" next wks End Sub Sub ProtectAll() dim wks as worksheet for each wks in activeworkbook.worksheets wks.protect password:="topsecret" next wks End Sub I would like to be able to modify this macro so that end users can format rows as needed. I am a beginnner macro user. Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modify general format to date format. | Excel Worksheet Functions | |||
Unable to modify the level of protection of macro | Excel Discussion (Misc queries) | |||
Modify Web Query using macros? | Excel Programming | |||
protection and macros | Excel Programming | |||
Protection & Macros | Excel Programming |