repeated question: how to protect sheets from within VBA?
 

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

repeated question: how to protect sheets from within VBA?
 

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.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"jon" wrote in message
...
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