| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting a row in excel 2000 although the worksheet is protected
Does somebody know if I can Inserting a row in excel 2000 although the
worksheet is protected? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Inserting a row in excel 2000 although the worksheet is protected
Yes
1) unprotect the sheet in your code, insert the row, protect the sheet 2) use the UserInterfaceOnly property of the protect method which allows code to make changes to a protected sheet. -- Regards, Tom Ogilvy "bartman1980" wrote: Does somebody know if I can Inserting a row in excel 2000 although the worksheet is protected? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting comment in unlocked cell of protected Excel worksheet? | Excel Worksheet Functions | |||
| Inserting comments on protected worksheet | Excel Programming | |||
| Excel 2000 Lists - Insert Row in Protected worksheet | Excel Discussion (Misc queries) | |||
| Sorting on a protected worksheet in Excel 2000 | Excel Worksheet Functions | |||
| INSERTING ROWS IN PROTECTED WORKSHEET | Excel Discussion (Misc queries) | |||
Linear Mode
