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

1 vote211 views1 answer
Extract the second word in a text in excel
VBA
0 vote194 views1 answer
Worksheet.pastespecial textbox
VBA
1 vote211 views1 answer
What does vbs stand for
VBA
5 votes201 views1 answer
Excel formula how to create strings containing double quotes
VBA
0 vote216 views1 answer
VBA Sleep Snippet
VBA
0 vote229 views1 answer
Tester si une case est vide vba
VBA
0 vote197 views1 answer
Check if program is running vbnet
VBA
22 votes268 views1 answer
Excel vba check if directory exists
VBA
1 vote215 views1 answer
Add rows to datagridview vb.net
VBA
0 vote206 views1 answer
Vbnet round to nearnest thousand
VBA