So, this is my first post -- I hope I do everything right.

I have a spreadsheet that has a Macros set to run on opening. It, through a series of other formulas, detects if a date written on the sheet is over 21 days before today. If it is, it clears out a certain range of cells. This part works perfectly (thanks to all the help on these forums), but the problem is, that the date on the spreadsheet is a paste link, and also Auto-updates on opening. If it updates before the macros runs, it won't ever be 21 days before today, so I was wondering if there was a code to let the macros run first, and then have all the links on the page update.

Thanks in advance everyone!