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 vote300 views1 answer
Excel vba copy entire sheet paste values
VBA
0 vote338 views1 answer
Get month number from month name vbnet
VBA
1 vote339 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
1 vote308 views1 answer
Add control vb
VBA
0 vote307 views1 answer
Excel run macro every 5 minutes
VBA
6 votes347 views1 answer
Excel vba isalpha
VBA
1 vote299 views1 answer
Excel vba first and last row and column in range
VBA
0 vote286 views1 answer
Excel vba assign shortcut key to button
VBA
5 votes324 views1 answer
Excel formula how to create strings containing double quotes
VBA
18 votes454 views3 answers
Excel-vba make integer
VBA