ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why can't I show or hide rows in an outline on a protected sheet? (https://www.excelbanter.com/excel-discussion-misc-queries/1593-why-cant-i-show-hide-rows-outline-protected-sheet.html)

rwlass

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?

Frank Kabel

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