Activesheet.Unprotect Password:="ABC"


ActiveSheet.Protect Password:="ABC"
ActiveWorkbook.Close Savechanges:=True

--
Regards,
Tom Ogilvy

"Theresa" wrote in message
...
Hi:

I have an Excel file that has been used as a template to create 800+ files
that has the protection worksheet applied. I now what to add more
formulas
to this file and want to use a macro to do it. How can I enter the
unprotect
password automaticcaly as part of the macro and then protect the sheet
again
before saving and closing?

Thanks