Hi

You have several "calculate" events in the workbook, but that would make it
pretty sluggish. Can't you use the Change event in "the cell were I type the
first value" ?

HTH. Best wishes Harald

"Php" skrev i melding
...

Hi again!

Now I think I understand why it is not working. I found this on the
site you posted:

"This event does not occur when the value is changed as the result of a
calculation"

I will try to explain more what I want to happen...

On my general sheet I have 16 cells numered from 1-16. These numbers
changes in the corresponding sheets when I change them. I also want the
sheet tab name to change when I change numbers. All cells are
calculations based on the cell were I type the first value.

Cant it be done because the cell values are results of calculations?

/Php


--
Php
------------------------------------------------------------------------
Php's Profile:
http://www.excelforum.com/member.php...o&userid=19971
View this thread: http://www.excelforum.com/showthread...hreadid=345792