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 vote290 views2 answers
Checking and changing system volume vb.net
VBA
0 vote249 views1 answer
Vba keep command window open
VBA
0 vote231 views1 answer
Excel vba assign shortcut key to button
VBA
0 vote263 views1 answer
Amd64 vs arm64 linux
VBA
0 vote253 views1 answer
Vba search string position
VBA
0 vote230 views1 answer
Excel vba calculate
VBA
3 votes264 views1 answer
Extract word in a text in excel
VBA
0 vote228 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
0 vote366 views2 answers
VB
VBA
1 vote248 views2 answers
Vba string length
VBA