worksheet

  • Thread starter Thread starter merf
  • Start date Start date
M

merf

Hi,

How can I prevent that someone can change the names of the different
worksheets, because one sheet is related to another and som formulas won't
work i that case.

thanks, merf
 
Hi
you can protect your workbook (goto 'Tools - Protection').
But if you are talking about formulas in one single workbook the
formulas will in nearly all circumstances adapt automatically if you
change the tab name 8one exception: INDIRECT, using the sheet name with
it's string parameter)
 
Back
Top