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 vote146 views1 answer
Excel vba convert cells address
VBA
0 vote138 views1 answer
Check range is in another range vba
VBA
0 vote145 views1 answer
Show unix time in vba
VBA
1 vote91 views1 answer
How to open cmd with vbd
VBA
1 vote137 views1 answer
Change the first item in a queue vb.net
VBA
0 vote147 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote139 views1 answer
Limit combobox to list vba
VBA
0 vote140 views1 answer
Vba sort the data Z to A
VBA
0 vote157 views1 answer
Iterate all file in a folder vba
VBA
0 vote132 views1 answer
Vba code for cutoff time
VBA