In the code for the data pull from SQL, at the very end of the sub place the
following:
Run "FormattingSub" 'use the name of your recorded macro

This will call the formatting sub to run only after the data pull is complete

"Steve Happ" wrote:

Hello:

Using Excel 2003

I have an Excel sheet that is set to refresh data using SQL upon open. That
works great. I also want to run a simple macro that I recorded and saved in
the worksheet that formats the data AFTER the data is pulled. How do I do
this?

I tried the auto_open macro, but that runs BEFORE the data is pulled. I
need it to run AFTER the data is pulled.

Thanks for your help

Steve