Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection.... after reprotect resets to defaults?
Hi There Im using "Sheets("Summary").Unprotect" and then ""Sheets("Summary").protect" at the start and end of a Macro. However when I reprotect the sheet, the "qualities" specified (not in VB, just by me manually selecting them) (see below) are not the same as before I ran the Macro. Question is whats the VB to protect and unprotect a workbook, but leaving the predefined qualities (see below) intact...? Users can do anything except for : 1) Type over locked cells 2) Insert or delete rows or columns Kind regards Darin *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection.... after reprotect resets to defaults?
If you use Excel 2002 or 2003 there are protect options when you use
ToolsProtection..Protect Sheet Record a macro when you check the options you want and look at the code -- Regards Ron de Bruin http://www.rondebruin.nl "Darin Kramer" wrote in message ... Hi There Im using "Sheets("Summary").Unprotect" and then ""Sheets("Summary").protect" at the start and end of a Macro. However when I reprotect the sheet, the "qualities" specified (not in VB, just by me manually selecting them) (see below) are not the same as before I ran the Macro. Question is whats the VB to protect and unprotect a workbook, but leaving the predefined qualities (see below) intact...? Users can do anything except for : 1) Type over locked cells 2) Insert or delete rows or columns Kind regards Darin *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection.... after reprotect resets to defaults?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spell Check Protect Reprotect with same settings | Excel Discussion (Misc queries) | |||
Interval accumulation and resets | Excel Discussion (Misc queries) | |||
Protect then reprotect using macro | Excel Discussion (Misc queries) | |||
Color Defaults, Package Resets & Downloads | Charts and Charting in Excel | |||
ScreenUpdating automatically resets to True | Excel Programming |