locking or protecting formulas
You could try temporarily converting your formulae to text with
Edit/Replace
Replace What: =
Replace With: %%
Then rename your sheets, set up the new sheets, and change your formulae
from text back to formulae
Edit/Replace
Replace What: %%
Replace With: =
Be sure to back up before trying.
"belvy123" wrote:
Hi all
I have a series of work sheets ( sheet1 thru sheet8) all are linked to
another sheet (sheet9) that displays the data that I need from each (sheet1
thru sheet9). I want to be able to rename any worksheet such as rename to
(sheet1a thru sheet8a)
and then create another blank copy of(sheet1 thru sheet8).
When I do this renaming, the formula automatically refers to the renamed
version of the original sheet "the formula that refered to sheet1 now refers
to sheet1a"
How can I protect my formula so it will always refer to sheet1 or shhet2 etc.
Please help. All else is working as I planned but this is messing it all up
--
cruchnin numbers
|