how to get a macro to run at a specific time
Posted by Kevin on November 26, 2001 6:49 AM
I have a spreadsheet that automatically queries an access database upon opening, and inserts data from the database in the spreadsheet. some of the columns are too narrow to show the data after the query runs, so I tried inserting an auto_open macro to resize the columns after opening the sheet. The trouble is the macro runs first, then the query runs and the columns revert back to being too narrow. How do I get this macro to run AFTER the query is finished refreshing and not before?
Thanks in advance,