Thread: repeated question: how to protect sheets from within VBA?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_3_] Dick Kusleika[_3_] is offline
external usenet poster
  
Posts: 599
Default 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




Reply With QuoteReply With Quote