Refresh External Data for Multiple Selected Sheets

Hello,

I have an excel document with about 30 different sheets (tabs). The sheets grab external data from web pages. However I never need all of the web pages to be refreshed each day I access the document to update the data. I tried creating a macro to set them this up. Basically, I have a sheet with about 30 different check box controls and 1 control button. Each check box has a working macro that automatically selects the corresponding sheet and refreshes it (there's a lot of data in each sheet to be refreshed, so it takes about 30 seconds to refresh each sheet). However, the macros of each check box run when I check off the check box. Ultimately, I wish that I can check off the check boxes without them running and then all of the selected check boxes run when I press the control button. That is beyond my scope of knowledge, but considering I have everything else set up in visual basic I feel like it would be a minor adjustment to the code.

I just want to be able to only refresh certain sheets. It takes too much of my time to select each sheet, click refresh for only that sheet, wait for it to refresh, and repeat the process. It also takes longer than I would like for the refresh all to finish.

If someone can help me with an excel trick to be able to refresh multiple (not all) sheets of a document OR an if statement for my code that only has the macro for that check box run when the check box is checked AND the control button macro is clicked.

Feel free to let me know if you have any questions for me to further clarify the situation.

Thank you so much for your help!

-GM-

Hi

I think I understand but is this what you are looking for?

Please Login or Register  to view this content.