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

0 vote140 views1 answer
Vba min
VBA
0 vote134 views1 answer
Vba nested dictionary
VBA
0 vote203 views1 answer
Find the name of the last excel sheet vb
VBA
1 vote156 views1 answer
Perform http request in vb.net
VBA
0 vote137 views1 answer
Prive sub enter clicked vb
VBA
0 vote107 views1 answer
How to self delete a vbscript file
VBA
8 votes245 views1 answer
Vba convert 2 bytes to an integer
VBA
1 vote129 views1 answer
Vba reverse string
VBA
0 vote131 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
1 vote124 views1 answer
VBA Loop through recordset
VBA