Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Booklet Protection Question
I have a booklet with about 20 sheets. I would like to unprotect and protect
the sheets together, not one at a time. Protecting the workbook doesn't protect the cells. Is there such a function? Thanks Mark |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Booklet Protection Question
Hi
This will work and a password is not required Macro for protecting and unprotecting worksheets. NOT USING A PASSWORD. Sub SheetLock() ' ' SheetLock Macro Application.ScreenUpdating = False Dim ws As Worksheet For Each ws In Worksheets ws.Protect Next ws Application.ScreenUpdating = True End Sub Sub SheetUnLock() ' ' SheetUnLock Macro Application.ScreenUpdating = False Dim ws As Worksheet For Each ws In Worksheets ws.Unprotect Next ws Application.ScreenUpdating = True End Sub HTH Michael M "MWB" wrote: I have a booklet with about 20 sheets. I would like to unprotect and protect the sheets together, not one at a time. Protecting the workbook doesn't protect the cells. Is there such a function? Thanks Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question about Excel | Excel Discussion (Misc queries) | |||
Best possible protection of worksheets in excel | Excel Worksheet Functions | |||
Excel Pivot Table Refresh Question | Excel Discussion (Misc queries) | |||
Cut and Paste Question for an Excel Guru | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions |