Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expand/collapse toolbar ribbon
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Expand Collapse Buttons | Excel Discussion (Misc queries) | |||
Expand/collapse | Excel Programming | |||
Expand and Collapse Columns | New Users to Excel | |||
HOW CAN I COLLAPSE AND EXPAND COLUMS | Excel Discussion (Misc queries) | |||
expand/collapse row button | Excel Discussion (Misc queries) |