Excel vba password protect

' Password for opening
ThisWorkbook.SaveAs Password:="my_password"
' Access granted, password required for modification
ThisWorkbook.SaveAs writeResPassword:="my_password2"

Excel vba protect worksheet without password

Worksheets("Sheet1").Unprotect "Password"

Source: automateexcel.com

Similar codes

18 votes464 views3 answers
Excel-vba make integer
VBA
1 vote287 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote304 views1 answer
Vba get text file content
VBA
0 vote319 views1 answer
Vba loop through textboxes
VBA
0 vote336 views2 answers
Get unique random number in vb.net
VBA
5 votes365 views1 answer
Excel-vba get integer high byte
VBA
0 vote328 views1 answer
Vba compare strings
VBA
5 votes330 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
0 vote339 views3 answers
Write to text file vb.net
VBA
0 vote321 views1 answer
Thread sleep vb
VBA