Public sub yourMacro()
Shetts("A").Unprotect "ABC"
'Your code
Sheets("A").Protect "ABC"
End Sub
--
----------------------------
Mauro Gamberini
Sheets("A").protect is how to protect a sheet, and similar
Sheets("B").Unprotect.
I run a Macro that first unprotects a sheet, then when Macro is finished
Re protects the sheet.
I want to now specify a password, lets say ABC.
Whats the VB to do that....?