Checking the state of the Ribbon bar

[mark hansen]

We are using XL 2007.
I use the send keys to get rid of the ribbon bar when some of my spreadsheet open. And again when they close, to put it back. Some of my users really like this and asked me how I did it., Well I told them and now some run without the ribbon bar.

The problem is when they open my spreadsheet, it puts it back, causing some confusion.

Is there a way to check the state of the ribbon bar (open or closed) and only use the send keys to close it if its Open?

 

[Andy Pope]

You can check the height of the ribbon using,

application.commandbars("Ribbon").height

xl2007 is 59 minimized and 150 shown.
xl2010 is 53 minimized, 141 shown.

Regardless of the actual height you can compare the height before and after the command then repeat command as required.

 

[mark hansen]

Oh woe, that's great Andy, thanks. I'll try it when i get to work tomorrow!!!
Thanks again!

Mark