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

6 votes142 views1 answer
Excel vba isalpha
VBA
4 votes128 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
4 votes136 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
0 vote109 views1 answer
Vba dropdown event
VBA
3 votes131 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
0 vote123 views1 answer
VB get external IP address
VBA
0 vote131 views1 answer
Default host vbox address
VBA
0 vote131 views1 answer
Excel vba DisplayAlerts
VBA
0 vote124 views1 answer
Excel vba hide gridlines
VBA
1 vote122 views1 answer
Vba date to unix timestamp
VBA