Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking Sheet Tabs
Is there a way to lock more than one sheet tab?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking Sheet Tabs
Hi,
I'm not sure I understand your terminology -"Lock sheet tab", what do you mean? Mike "PFLY" wrote: Is there a way to lock more than one sheet tab? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking Sheet Tabs
What do you mean by this?
Placing sheet protection on more than one worksheet? One at a time or with VBA you can do all or those in a selected group of sheets. Sub ProtectAllSheets() Application.ScreenUpdating = False Dim n As Single For n = 1 To Sheets.Count Sheets(n).Protect Password:="justme" 'Sheets(n).UnProtect Password:="justme" Next n Application.ScreenUpdating = True End Sub Sub Protect_Selected_Sheets() Set MySheets = ActiveWindow.SelectedSheets For Each ws In MySheets ws.Select ws.Protect Password:="justme" 'ws.UnProtect Password:="justme" Next ws End Sub Gord Dibben MS Excel MVP On Thu, 2 Aug 2007 12:28:03 -0700, PFLY wrote: Is there a way to lock more than one sheet tab? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking A sheet | Excel Discussion (Misc queries) | |||
Locking Data Sheet | Excel Discussion (Misc queries) | |||
locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
Locking a sheet?? | Excel Discussion (Misc queries) | |||
locking tabs w/macros | Excel Discussion (Misc queries) |