View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LinLin LinLin is offline
external usenet poster
 
Posts: 46
Default Protection - Allow Group/Ungroup but lock / unlock some cells

Hi Everyone

I have a spreadsheet which allows people to enter some figures in some cells.
Those cells then add together to creat bew totals.

I want to allow them to see all the individual lines or allow them to use
the group +or - (the rows have already been grouped) to change the views.

But, if I lock some cells in those rows, the Group + or - no longer works.

Is there anyway around? I've tried "Allow Format rows" as a protection
option but it didn't work. I've tried to select the whole worksheet, unlocked
it, then locked smalls parts, that didn't work either.

If there is a solution, I'd love to hear from you!