Peter T wrote:
"Elkar" wrote in message

Comments in-line

On opening, I receive the error: "Run-time error '424': Object Required".
Hitting Debug points me to these lines (depending which condition is met):

SubmitReport.Enabled = True
SubmitReport.Enabled = False

SubmitReport is a button on the worksheet 'Reconcilliation'.

Sounds like there is no ActiveX control named "SubmitReport" on the sheet
whose code module includes the calculate event. Is the sheet named
'Reconcilliation' that which includes the calculate event. Is 'SubmitReport'
an aX control.

More likely there isn't one at the point where the code executes when
macro security is set to automatic. In manual mode there is plenty of
time to draw any controls before this VBA code executes, but there could
easily be a race condition if the macros are fully enabled.

The graphic engine in XL2007 is asynchoronous and very slow.

Regards,
Martin Brown