This is SO, SO close! The only thing is when the file is opened, I still
want the menu 'tabs' to be visible so the user can select them if necessary.
In other words, I only want the menu ribbon itself to be collapsed---not the
tabs or the user's quick access toolbar. Is there anything else I can try??
If not, I will definitely go forward with your suggestion since it is still
better than what I had before!

"Rick Rothstein" wrote:

Try these instead...

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

Show: ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"

--
Rick (MVP - Excel)


"jday" wrote in message
...
I am having an issue with my Auto_Open and Auto_Close macros, where I am
basically trying to make sure the toolbar ribbon is "collapsed" when the
user
opens the workbook, and "expanded" when they close it. I found a
suggestion
from a previous post on this topic -- below is the code that was
recommended:

(Auto_Open)
If Application.CommandBars("Ribbon").Height 80 Then SendKeys "^{F1}"

(Auto_Close)
If Application.CommandBars("Ribbon").Height < 80 Then SendKeys "^{F1}"

The Auto_Open macro works correctly---it ensures the ribbon is "collapsed"
upon opening the file. The problem is when the file is closed---for some
reason, instead of expanding the ribbon, it opens up the Help window
instead
(the ribbon stays collapsed). Ideally, I would like to have the
Auto_Close
procedure "restore" the ribbon to whatever the user had previously (either
collapsed or expanded) -- but I would settle for having it "always" expand
the ribbon when the file is closed to accommodate majority of users. What
is
wrong with my current Auto_Close procedure?