Pinaceous
Well-known Member
- Joined
- Jun 11, 2014
- Messages
- 1,124
- Office Version
- 365
- Platform
- Windows
Good Day Everyone,
I'm working with a sheet that has all of its sheet cells locked with a password in respect to its workbook and protect sheet functions:
I'd like all of the cells upon to remain locked except "B11:AF180, AH11:AH180" upon that sheet with new sub.
Does anyone have any advice as I am stumped, thanks!
Respectfully,
pinaceous
I'm working with a sheet that has all of its sheet cells locked with a password in respect to its workbook and protect sheet functions:
VBA Code:
Sub LockWorkbook()
ActiveWorkbook.Protect "Password", Structure:=True, Windows:=True
End Sub
VBA Code:
Sub ProtectSheets()
Dim ws As Worksheet
Dim pwd As String
pwd = "Password" 'Put your password here
For Each ws In Worksheets
ws.Protect Password:=pwd
Next ws
End Sub
I'd like all of the cells upon to remain locked except "B11:AF180, AH11:AH180" upon that sheet with new sub.
Does anyone have any advice as I am stumped, thanks!
Respectfully,
pinaceous