Hi

Here is a nice little bit of code, that, when you change the value of a
cell using a validation scroll down list, it runs a macro:


Code:
--------------------

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$6" Then
Application.Run "yourmacro"
End If
End Sub

--------------------


It works great on one very simple file I have with maybe less than 200
calculations on the page, where once I select from the scroll down list
and change the value in the cell it triggers the macro without incident.
But the *other* file has too many calcs I guess.

I discovered that I can get the macro above to work on the file with
the heavier concentration of calculations IF I turn off the automatic
calculations, but then they have to be *manually* turned off, which
defeats the purpose of the convenience of the scroll down list.

Does anybody know how to get past this little bug?

Many thanks as always

tx


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