| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect ALL sheets in one coded macro
How can i word a code to protect ALL sheets in a workbook in a single step,
rather than individually? Sub protect() ' Macro recorded 24-11-2006 by Corey ' ThisWorkbook.Worksheets("Sheet 10").protect Password:="1234" ' <=== Some thing like this workbook.worksheets(all).protect password:="1234" ActiveSheet.protect End Sub How can i write this? Corey.... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Protect Mult Sheets / but allow Pivot Tables... | Excel Worksheet Functions | |||
| Macro to protect multiple sheets? | Excel Worksheet Functions | |||
| Use Macro to protect choosen sheets in workbook | Excel Discussion (Misc queries) | |||
| Macro - settings to protect sheets | Excel Programming | |||
| Protect sheets from editing but allowing macro to do so? | Excel Programming | |||
Threaded Mode
