PERSONAL.XLSB running before Excel has loaded

[Aaron092]

Hi again
(Previous thread: http://www.excelforum.com/excel-prog...is-opened.html)

Using the code that romperstomper gave, I've put part of my macro in, but the first part is an If function which checks whether a string is present in specific cells.

Please Login or Register  to view this content.

Is there any way to stall the macro from running to let the file load properly please?

I've tried a few Application.Waits and Application.Refresh but got nowhere.

Thanks again

Aaron

[Aaron092]

Any help is appreciated