View Single Post
  #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?