Thanks Rick,

I'm a self taught 'exceller' so I was having a bit of trouble. It works well.

Much appreciated. Jeff (Australia)
--

"Rick Rothstein (MVP - VB)" wrote:

Minimize the Ribbon? Do you mean *hide* the Ribbon? If you execute this
line...

ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"", False)"

in the Workbook_Open event, and if the user Enables Macros, then the Ribbon
will be *hidden* at startup. If you ever want to bring it back via code,
change the False to True.

Rick


"Jeff Wiggins" wrote in message
...
Hi,

I am trying to get an Auto_Open macro to minimise the ribbon in Excel
2007,
but the Ctrl+F1 won't appear in the macro.
Can someone please let me know what I am doing wrong ?
--
Thanks in advance,
Jeff