Locking Sheet Tabs
Is there a way to lock more than one sheet tab?
|
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? |
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? |
All times are GMT +1. The time now is 11:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com