Supressing worksheet jumping

[mr_pivot]

I have created a macro to go to 5 worksheets and update filters on each sheet. I did this via recording mouse clicks. As I expected, when I run the macro it jumps to each worksheet and back to a cell on my starting worksheet.

Is there a way to set this up to updated the filters without having to jump to each worksheet? Can I suppress the worksheets from being displayed and update the filters without actually seeing this on screen?

 

[VoG]

Hello and welcome to MrExcel.

Try adding this line near the top of your macro

Application.ScreenUpdating = False

and set it to True before the End Sub statement.

Or post your recorded code and it can probably be cleaned up to avoid selecting sheets at all.

 

[mooseman]

Put this at the beggining of your code
Application.ScreenUpdating = False
and this at the end
Application.ScreenUpdating = True

 

[mooseman]

VoG, you are like Speedy Gonzalez... the fastest answers in all Mr.Excel.....

 

[mr_pivot]

Holy cow!

You are fast and that did the trick. I have other places to use it as well!

MP

 

[VoG]

If you use recorded macros a lot you should find this of interest http://www.tushar-mehta.com/excel/vba/beyond_the_macro_recorder/

 

[mr_pivot]

Thanks.

I use them to make up for my lack of knowledge in VBA. It helps to learn code once I have done it thru mouse clicks.

 

[VoG]

Nothing wrong with recording macros at all. I still use the recorder when I can't remember the syntax for commands that I rarely use (like manipulating charts). But the recorder does a lot of selecting which is unnecessary and slows the code down.