Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
rwlass
 
Posts: n/a
Default 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?
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hide column but show chart Svetlana Charts and Charting in Excel 1 January 14th 05 09:49 AM
sorting detail rows - summary row in an outline ExcelSteve Excel Discussion (Misc queries) 1 December 5th 04 02:40 PM


All times are GMT +1. The time now is 08:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"