View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PJ PJ is offline
external usenet poster
 
Posts: 112
Default Lock location of sheet within a spreadsheet

Is there a way to lock the location of a sheet within a spreadsheet? I have
a spreadsheet that has a sheet for each employee. Then I have a Total sheet
that totals across all the sheets. For example, the Total sheet adds cell C3
on Sheet 1 plus C3 on Sheet 2 plus C3 on Sheet 3, etc. I want to lock Sheet
1 so it can't be moved because the formula will not work if the sheets are
rearranged. See formula below.

=SUM('Sheet1:Sheet10'!C3)

--
Thanks,
PJ