As is you must put the code in a standard module and run the macro manually.
If you want it to happen after typing then you call it from the worksheet's
Change event. See
http://www.cpearson.com/excel/events.htm
on events.

I can't offer a working solution, you explain this very general "to change
e.g. the tab name on sheet 15 from a cell", and which sheet / which cell is
of greatest importance.

HTH



"Php" skrev i melding
...

Hi Harald,

Thank you for your answer, but it still does not work. Maybe I placed
the code in the wrong place? Is it supposed to be under the
'ThisWorkBook' or under the specific sheets 'General' or sheet15?

I have tried different places, but the thing I'm confused about is tha
when I change the cell value from e.g. 1 to 5 nothing happens with
sheet15 tab name. Must the code be triggered by something because sheet
15 is not the active sheet when I change the value?

regards
/Php


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