Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controls in protected sheet don't response!!!
Hi, Geeks!!
1. Can any one tell me if it is possible to activate the controls in the proctected sheet? One of the control has to delete the rows. I can't!! 2. Any idea to reduce the security level to low through VBA in Excel 2003!! 3. How to protect the sheet from being deleted? I need a VBA code to do this. Please help!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controls in protected sheet don't response!!!
Hi
You can not delete rows etc. in a protected sheet. A solution could be to wrote a macro which unprotect the sheet, delete the selected row(s), and protect the sheet again. The macro can be called from a button on the sheet. To prevent sheet(s) from beeing deleted, you have to protect the workbook for structure. Hopes this helps. .... Per "Rose Tamang 2001" skrev i meddelelsen ... Hi, Geeks!! 1. Can any one tell me if it is possible to activate the controls in the proctected sheet? One of the control has to delete the rows. I can't!! 2. Any idea to reduce the security level to low through VBA in Excel 2003!! 3. How to protect the sheet from being deleted? I need a VBA code to do this. Please help!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Controls in protected sheet don't response!!! | Excel Programming | |||
how to activate controls in protected sheet | Excel Worksheet Functions | |||
Controls in protected sheet | Excel Programming | |||
Unable to use controls when sheet is protected | Excel Programming | |||
Unable to use controls when sheet is protected | Excel Programming |