Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have created an outline on an Excel 2000 Spreadsheet. This is a shared
workbook and I have locked certain cells that I don't want changed. However, when I protect the worksheet, Excel will not allow me to show or hide the rows in the outline. When I try, I get a message window that says " You cannot use this command on a protected sheet" then tells me how to unprotect the sheet. I need to be able to protect the locked cells from being changed, but allow showing and hiding of the outlined rows. Is this possible? |
#2
![]() |
|||
|
|||
![]()
Hi
AFAIK not possible -- Regards Frank Kabel Frankfurt, Germany "rwlass" schrieb im Newsbeitrag ... I have created an outline on an Excel 2000 Spreadsheet. This is a shared workbook and I have locked certain cells that I don't want changed. However, when I protect the worksheet, Excel will not allow me to show or hide the rows in the outline. When I try, I get a message window that says " You cannot use this command on a protected sheet" then tells me how to unprotect the sheet. I need to be able to protect the locked cells from being changed, but allow showing and hiding of the outlined rows. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
hide column but show chart | Charts and Charting in Excel | |||
sorting detail rows - summary row in an outline | Excel Discussion (Misc queries) |