Hi

I’m trying to write some VB code in Excel to check whether a compile error box pops up upon opening a workbook and if so selecting ok.

I would usually record a macro and then manipulate the code, however in this example I don’t have the record option available to me. Also, the opening of the file is part of the code already, so I want to avoid having to manually select ok.

I’d be very grateful if anyone out there is aware of a fairly straight forward solution to this so I can simply paste the code into my module.

Thanks

J