| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Preventing "Protect Workbook"
Is there any way to disable the "Protect Workbook"
button in Excel 2007?? Just curious if there any ways to prevent this option. The reason I'm asking about this is because my workbook contains lots of VBA code in which I set a sheet's "visible" property to "xlVeryHidden" or "xlVisible". So, if someone protects the workbook, the VBA code in the workbook will crash if it encounters a line of code that attempts to change any sheet's "visible" property. thank u |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect "Copy" and "Save As" changes to workbook | Excel Discussion (Misc queries) | |||
| Preventing Auto_Open() runnng on vpc -Holding "Shift" doesn't work | Excel Programming | |||
| Add "Protect ALL Sheets" that is the same as "Protect Sheet" | Excel Worksheet Functions | |||
| ".Protect userinterfaceonly:=True" & ".EnableSelection = xlUnlockedCells" not tabing | Excel Programming | |||
| Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc | Excel Programming | |||
Threaded Mode
