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 vote240 views2 answers
Excel vba number format file size
VBA
0 vote223 views1 answer
Excel vba assign shortcut key to button
VBA
0 vote224 views1 answer
Excel vba disable keyboard input
VBA
0 vote234 views1 answer
Vb.net visible property dgv collumn not working
VBA
8 votes375 views1 answer
Excel vba determine number of elements in a 1D array
VBA
0 vote215 views1 answer
Vbnet get file name from path
VBA
0 vote250 views1 answer
Freeze panes vba
VBA
1 vote215 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
0 vote216 views1 answer
Vba leading zeros in string
VBA
5 votes264 views1 answer
Excel vba how to unit test vba code
VBA