Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protecting Multiple Worksheets at the same time
Is there a way to protect multiple worksheets at the same time, instead of
having to protect each worksheet one-by-one. Selecting 'Protect Workbook' does not do the same thing as 'Protect Worksheet'. I want it so that no cells can be modified on any worksheet. I tried Grouping the Worksheets, but then 'Protect Worksheet' is no longer available. -- Doug P. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protecting Multiple Worksheets at the same time
On Sep 19, 5:46 pm, Doug P. wrote:
Is there a way to protect multiple worksheets at the same time, instead of having to protect each worksheet one-by-one. Selecting 'Protect Workbook' does not do the same thing as 'Protect Worksheet'. I want it so that no cells can be modified on any worksheet. I tried Grouping the Worksheets, but then 'Protect Worksheet' is no longer available. -- Doug P. Not that I know of. But you could do this with a VBA routine. Something like this (untested) would protect all of the worksheets in the active workbook. Sub foo() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True End With End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating multiple graphs in multiple worksheets at the same time | Excel Discussion (Misc queries) | |||
multiple time stamps on worksheets | Excel Discussion (Misc queries) | |||
Protecting multiple worksheets. | Excel Discussion (Misc queries) | |||
protecting multiple worksheets | Excel Discussion (Misc queries) | |||
How do I add time (in mm:ss) from multiple worksheets? | Excel Worksheet Functions |