Why can't I show or hide rows in an outline on a protected sheet?

G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Group and Outline on a Protected Sheet 14
Unprotect Combo Box in a Protected Sheet 3
allow merging cells in protected sheet 1
Deleting Rows form Protected Sheet 1
hide columns on a protected sheet??? 1
Sheet protection and "Group and Outline" 8
How do I remove the outline protection in Excel sheet? 1
Protecting a Sheet 7

Top