Problem with INDIRECT in event handlers

frajaro · Apr 20th, 2002, 03:12 PM

When I use the event procedure Worksheet_calculate in a worksheet containing INDIRECT funtions, the handler event activates WS_change instead of WS_calculate.

Could you help me to solve this problem?
thanks in advance.

Juan Pablo González · Apr 20th, 2002, 03:33 PM

The Calculate event isn't the best method to use, because it can slow you down a lot. So, it's "kind" of a nice thing to use the Change event instead... why can't you use the Change, or in other words, why do you need to use the Calculate event ?

frajaro · Apr 22nd, 2002, 01:47 AM

Thanks Juan Pablo,

I use the event calculate to run a macro -related to graphics- every time I do a selection of a pivot table and this doesn't work with change event. Maybe you can give me an advice on a different method to run macros connected with pivot tables.
On the other hand, I would prefer not to have the macro run in any change in the worksheet but only when it is really necessary, that is, when a new calculation is made.

regards
Francisco

Apr 20th, 2002, 03:33 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	The Calculate event isn't the best method to use, because it can slow you down a lot. So, it's "kind" of a nice thing to use the Change event instead... why can't you use the Change, or in other words, why do you need to use the Calculate event ? __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 20th, 2002, 03:12 PM	#1
frajaro New Member Join Date: Mar 2002 Posts: 13	When I use the event procedure Worksheet_calculate in a worksheet containing INDIRECT funtions, the handler event activates WS_change instead of WS_calculate. Could you help me to solve this problem? thanks in advance.

Apr 22nd, 2002, 01:47 AM	#3
frajaro New Member Join Date: Mar 2002 Posts: 13	Thanks Juan Pablo, I use the event calculate to run a macro -related to graphics- every time I do a selection of a pivot table and this doesn't work with change event. Maybe you can give me an advice on a different method to run macros connected with pivot tables. On the other hand, I would prefer not to have the macro run in any change in the worksheet but only when it is really necessary, that is, when a new calculation is made. regards Francisco