repeated question: how to protect sheets from within VBA?

J

jon

I need to protect all of the sheets in my AddIn before I release it, but I
don't want them to be protected while I'm doing development. Is there any
way to protect the sheets when the AddIn is loaded, or at some other time?
I'm using Excel 97...

:)

Jon
 
D

Dick Kusleika

Jon

Why don't you do your development, then protect the sheets, then save? You
could use the Workbook_Open event of the add-in, but it seems unnecessary.
 
Top