| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro to protect multiple sheets?
Hello! Thanks in advance for your help.
How can I modify the macro (below line) I recorded to protect a sheet so that I can use it multiple sheets at once. I have a workbook with 20 tabs. I'd like to be able to protect and unprotect all sheets at once. _________________________ PROTECTSHEET Macro Keyboard Shortcut: Ctrl+p ActiveSheet.Protect Password:="mypassword", DrawingObjects:=True, Contents:=True, Scenarios:=True __________________________ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use Macro to protect choosen sheets in workbook | Excel Discussion (Misc queries) | |||
| macro to compile columns on multiple sheets | Excel Discussion (Misc queries) | |||
| creating macro working across multiple sheets | Excel Worksheet Functions | |||
| How do I protect multiple sheets at one time? | Excel Worksheet Functions | |||
| How do I protect formula cells on multiple sheets? | Excel Worksheet Functions | |||
Threaded Mode
