Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting Sheets - Excel 2000
Is it possible to protect more than one sheet at a time using Excel 2000?
-- LPS |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting Sheets - Excel 2000
Only through VBA code.
Sub ProtectAllSheets() Application.ScreenUpdating = False Dim n As Single For n = 1 To Sheets.Count Sheets(n).Protect Password:="justme" Next n Application.ScreenUpdating = True End Sub Sub UnprotectAllSheets() Application.ScreenUpdating = False Dim n As Single For n = 1 To Sheets.Count Sheets(n).Unprotect Password:="justme" Next n Application.ScreenUpdating = True End Sub For just the selected sheets................. Sub Protect_Selected_Sheets() Set MySheets = ActiveWindow.SelectedSheets For Each ws In MySheets ws.Select ws.Protect Password:="justme" Next ws End Sub Gord Dibben MS Excel MVP On Wed, 11 Jul 2007 09:38:06 -0700, LPS wrote: Is it possible to protect more than one sheet at a time using Excel 2000? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help w/ protecting all sheets | Excel Discussion (Misc queries) | |||
Protecting Sheets | Excel Worksheet Functions | |||
Protecting Sheets | Excel Discussion (Misc queries) | |||
Password Protecting Sheets in Excel So Others Can't See Certain Sh | Excel Worksheet Functions | |||
Protecting sheets | Excel Discussion (Misc queries) |