| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Question about repeated usage of a formula | Excel Discussion (Misc queries) | |||
| Protect some sheets in an xls but not all. | Excel Worksheet Functions | |||
| Printing text in a repeated cell/row that is longer than repeated | Excel Discussion (Misc queries) | |||
| Protect all Sheets | Excel Discussion (Misc queries) | |||
| Protect a few sheets | Excel Programming | |||
Linear Mode
