OK, it was hard to explain it in the subject line.

I have a button on an Access Application, that I want to Open up Excel, and invoke an excel Form with buttons. Each button runs a Macro. Simple as that.

In Excel I have a Auto_Open() function that loads a simple form that displays a few buttons (1 per Macro). The problem that I have is that the Excel form opens up, without opening Excel Workbook. So when the macro is finished, the form closes and i'm back in the Access Application, without ever opeing up the Excel Workbook !

Anyone know how I can ensure that the Excel Workbook opens before the form i displayed?

FYI - If I remove the Load form in the Auto_Open(), then the Workbook is opened and displayed, but the form is not invoked obviously....

Any help would be greatly appreciated !

Also, Is there a way to supress the form that Excel shows indicating that there are Macros...

Thanks so much,
Acie