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 vote126 views1 answer
Write listbox to text file vb.net
VBA
0 vote150 views1 answer
Excel vba delete columns in range
VBA
0 vote144 views1 answer
Excel vba convert cells address
VBA
0 vote128 views1 answer
Excel vba disable alerts
VBA
0 vote130 views1 answer
Delete rows in excel vba code
VBA
1 vote120 views1 answer
Excel vba first row in range
VBA
0 vote76 views1 answer
How to sort datagridview in vb.net
VBA
0 vote110 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
0 vote135 views1 answer
Vba keep command window open
VBA
0 vote141 views1 answer
Como ler subitem de um array em json usando vbnet
VBA