Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Too many calculations preventing Private Sub from executing macro
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Too many calculations preventing Private Sub from executing macro
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Preventing macro from .xlt from executing in a .xls | Excel Programming | |||
private macro and shortcut key | Excel Programming | |||
re : Possible to run private sub macros by writing another private | Excel Programming | |||
Option Private Module not preventing cross project referencing | Excel Programming | |||
Private Sub Running Other Private Sub Inadvertently | Excel Programming |