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 vote252 views1 answer
VBA
VBA
3 votes226 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
0 vote232 views1 answer
Vbs expand env var
VBA
0 vote251 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
1 vote232 views1 answer
Excel vba force recalculation
VBA
0 vote215 views1 answer
Vb check if row has column
VBA
0 vote223 views1 answer
Excel vba copy entire sheet paste values
VBA
0 vote243 views1 answer
Vba random number
VBA
0 vote215 views1 answer
Excel vba remove formatting from cell
VBA
0 vote229 views1 answer
Vb run command
VBA