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)
 
You must log in or register to reply here.

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

password on a worksheet 3
Can I use a worksheet name in a formula? 4
Prevent users to use a workbook/sheet after a specified day 2
Variable to rename a tab in a worksheet via VBA 5
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Donot allow user to change name of the worksheet 2
Need to have an index sheet but all other sheets should be hidden 1
Using Worksheet Name in Code/Formula 4

Back
Top