Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Password protecting certain worksheets in a file
How do I set passwords to protect just certain worksheets
in a file? |
#2
|
|||
|
|||
If you mean worksheet passwords, one way:
Public Sub ProtectSomeButNotAll() Const sPWORD As String = "drowwsap" Dim vSheets As Variant Dim i As Long vSheets = Array("Sheet1", "Sheet3", "Sheet5") For i = LBound(vSheets) To UBound(vSheets) Worksheets(vSheets(i)).Protect sPWORD Next i End Sub In article , "Mike" wrote: How do I set passwords to protect just certain worksheets in a file? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
One file splitted into worksheets | Excel Worksheet Functions | |||
bypass password when update linking of password protected file | Excel Discussion (Misc queries) | |||
password for worksheets cont... | Excel Worksheet Functions | |||
How to protect and unprotect 30 worksheets in a file every month . | Excel Worksheet Functions | |||
Password error after file opens | Excel Worksheet Functions |