Hi Gary

Thanks for the reply.

I gave yopur code a try, but it seems as if when there are X number of
calculations (or more) in an excel worksheet, you simply cannot run a
macro when you select from a scroll down list. The only way to get it
to work (the Private sub variety like being discussed) is to force the
macro to work by clicking into the cell, changing the value and then
hitting enter. Not very elegant but it works.

Unless of course there is another solution.


Thanks again

tx


--
tx12345
------------------------------------------------------------------------
tx12345's Profile: http://www.excelforum.com/member.php...o&userid=24776
View this thread: http://www.excelforum.com/showthread...hreadid=522281