![]() |
Why can't I show or hide rows in an outline on a protected sheet?
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? |
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? |
All times are GMT +1. The time now is 07:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com