AutoOpen not kicking in when opened by a macro

[Carly]

Hi guys,

I have an AutoOpen module in Excel which selects some textboxes...see below.

Sub Autpen()

Sheets("MACRO").chkAll.Value = True
Sheets("MACRO").chkOriginal.Value = True
Sheets("MACRO").chkBranchManaged.Value = True
Sheets("MACRO").chkNational.Value = True
Sheets("MACRO").chkDublin.Value = True

Range("D7").Select

End Sub

This workbook is opened via a macro from Access but this AutoOpen module does not kick in, however, it does work when the workbook is opened manually.

Anyone got any ideas?

Kind Regards

Carly

 

[Andrew Poulsom]

Have you tried putting your code in the Workbook_Open event procedure?

 

[Carly]

Thank you ever so much...so simple!