View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Trini_Suize Trini_Suize is offline
external usenet poster
 
Posts: 1
Default Protect worksheet but expand and collapse outline?

I'm currently using Excel 2003 and building a spreadsheet that has a lot of
columns and formulae. I protected the sheet and unlocked the relevant cells.
However, before protecting the sheet, I also outlined the sheet making it
easy to expand and collapse the relevant months. But when the sheet is
protected, I lose this functionality. Is there any way to protect the sheet
but still allow users to expand and collapse the relevant months?