Macro should run without switching sheets

[barnett2000]

I have a macro that calls other macros that go to other tabs, look at the data, then hide some rows. I've tried putting the Application.ScreenUpdating = False command at various places in both the main macro and the macros that are called by the main macro, but no matter what I've tried, when the macro runs, the screen flicks over to those other tabs. Any thoughts? The macros are below. The UPDATEALLSHEETS macro is the first one, which calls the other ones.

Please Login or Register  to view this content.

[Mordred]

You need to add code tags to your code.

[barnett2000]

I don't know what code tags are. I'll google it, though.

[barnett2000]

Okay, I see what code tags are. I thought you were answering my question at first. I added the code tags to the original post. Still seeking an answer.

[Mordred]

Hi barnett2000, I recall having this issue in the past and a great Excel guru named romperstomper gave me a variation of what I'm giving you. Try the following:

Please Login or Register  to view this content.

PS. Sorry for the late reply.