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 vote281 views1 answer
Vbnet line chart showing extra space
VBA
0 vote262 views1 answer
Create new worksheet excel visual basic
VBA
0 vote290 views1 answer
Excel vba join variant array
VBA
0 vote310 views1 answer
Excel vba named range exists
VBA
13 votes389 views2 answers
Vba write text file
VBA
0 vote302 views1 answer
Group controls programmatically vb
VBA
0 vote290 views1 answer
Excel vba disable keyboard input
VBA
1 vote282 views1 answer
Add a index column power bi
VBA
0 vote275 views1 answer
Excel vba copy entire sheet paste values
VBA
0 vote316 views4 answers
Vgrive,deb
VBA