repeated question: how to protect sheets from within VBA?

  • Thread starter Thread starter jon
  • Start date Start date
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
 
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.
 
Back
Top