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 vote205 views1 answer
Search in richtextbox vb.net
VBA
1 vote208 views1 answer
Excel vba autofit
VBA
1 vote203 views1 answer
Add a index column power bi
VBA
1 vote206 views1 answer
Excel date to unix timestamp
VBA
0 vote220 views2 answers
S yyyy-MM-dd em vb net
VBA
0 vote224 views1 answer
Vba table header name
VBA
0 vote220 views1 answer
Filesystemobject vba reference
VBA
0 vote239 views1 answer
Vba foreach 2d array
VBA
0 vote208 views1 answer
Openfiledialog specific folder
VBA
0 vote212 views1 answer
Vba apostrophe chr
VBA