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 vote253 views1 answer
Vba array of integers
VBA
0 vote198 views1 answer
Excel vba paste all to each sheet in workbook
VBA
0 vote186 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote188 views1 answer
Vbnet chart make 0 gridline line different color
VBA
1 vote174 views1 answer
Excel vba hide zero values
VBA
0 vote188 views1 answer
Openfiledialog specific folder
VBA
1 vote182 views1 answer
Add control vb
VBA
0 vote176 views1 answer
Le contrôle SpinButton (Toupie)
VBA
0 vote190 views1 answer
Search combobox items vb.net
VBA
0 vote180 views1 answer
Vbnet check if sting contians symbols
VBA