Macro help on dynamic sheet
 

I have the following question need help:

I want to make my dynamically generated worksheet has the function so
that
user can modify a cell value and then update the other cells
accordingly. I
know Worksheet_Change can be used for this purpose and it has to be
put
behind the sheet object.

Since all of the sheets will be dynamically created in my case (that
means I
can not put the code behind the sheet), is there any other way I can do
to
work around?

Thnaks


--
xiaofeng
------------------------------------------------------------------------
xiaofeng's Profile: http://www.excelforum.com/member.php...o&userid=23719
View this thread: http://www.excelforum.com/showthread...hreadid=373953