Run Macros while staying on a Main page

[dshuman]

I have a tool created using Macros and importing data from a database. There are probably 15 tabs that query and analyze data, but they all feed to a Main tab. When I press the button on the main page it goes to each tab to refresh the query and other activities, then returns to the main page to show the data I want.

Is there a way to make this Macro do all of this while staying on the Main page? Ideally I would like to hide all the other pages, and while the macros are running the only thing you see is the main page.

One step further - how would I add a status bar to indicate how much of the macro is complete (takes about 2 minutes to run)

 

[texasalynn]

Welcome to MrExcel Board...
add this to the start of your macro

Application.ScreenUpdating = False

and then just before the end sub add

Application.ScreenUpdating = True

do a search on this forum for "Progress Bar" as there are some great suggestions

 

[Smitty]

Welcome to the Board!

It's generally not necessary to select sheets in order to work with them. In addition to Texaslynn's comments if you post your code, I'm sure someone can optimize it for you.

You might also want to look into Excel's RefreshAll.

See : http://support.microsoft.com/kb/248204

& http://www.ozgrid.com/forum/showthread.php?t=67017

Hope that helps,