How to stop sheet calculation during a macro.

**mrgillus** · 08-20-2009, 10:32 AM

It is actually just a bit more complicated than the title says.

Example: I have Sheet 2 set to autocalculate on activate using vb. So when you click on that tab "Sheet 2" it will autocalculate.

My Question is, I have another macro that is copying information between Sheet 1 and Sheet 2. And I don't want calculation to occur during the macro but since it has to select Sheet 2 it performs the autocalculate.

Do I have any options to prevent the calculation from occuring when I run my copy paste macro?

I only want it to autocalculate when the user selects sheet 2

Thanks for the help!

**Phil_V** · 08-20-2009, 10:58 AM

Before you do your copy and paste do:

Please Login or Register  to view this content.

When you are done set it back:

Please Login or Register  to view this content.

Whilst it is false it will stop all event handlers from operating, (Change, SelectionChange, Activate etc etc)

**JBeaucaire** · 08-20-2009, 11:04 AM

Also, this may help:

Please Login or Register  to view this content.

**mrgillus** · 08-20-2009, 11:23 AM

I will try the events line- as for disabling and enabling during the macro that didn't work since the code to calculate was in the Activate Sheet command so everytime the macro would activate that sheet it would inadvertantly calculate.. This is turning into a frusterating day I must say.. I'm getting ready to post another problem lol.. I really doubt their is a fix to it though.. Thinking I will probably have to change the method to my madness altogether.. but enough on that.. another post to come