Losing Excel 2007 Ribbon with MSVDM

[markdibley]

Hello

This is a bit of an annoyance for me and is probably not very common. I use Microsoft Virtual Desktop Manager which gives me 4 different desktops to switch between.

When I am using Excel 2007 and I switch desktops, when I return all the menus/ribbon has gone so all I am left with is the spreadsheet and formula bar. (I used to use ctrl+1,2,3,4 to switch desktops. Now I use WinKey+1,2,3,4).

Is there any way to force Excel either to retain the ribbon or to reactivate it?

As I said, it's a rare one, but any advice would be great. Thanks

 

[markdibley]

I see a few people have read this thread, but no-one has suggested a solution. I worry I may not have explained things clearly so if there is any other information you think might be helpful please let me know.

Thanks

 

[xenou]

Not sure - there is a choice to "show" or "hide" the ribbon. Is that all that's involved. Unfortunately, no experience with Windows desktop manager. Do MS provide that at its site or do you have to buy it?

Alex

 

[ZVI]

Is this what you are after?

Sub Hide_Unhide_Ribbons()
Application.SendKeys ("^{F1}")
End Sub

Sub HideRibbon()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
End Sub

Sub ShowRibbon()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"
End Sub

May be you touch Ctrl-F1 instead of Ctrl-1?
If so just do Ctrl-F1 ones more.

 

[markdibley]

Hello

I tried this and Ctrl-F1 does work and un/hides the ribbon.

Sadly, however, Ctrl-F1 does not restore the ribbon after switching between desktops.

I suspect it is a focus issue as I have focus problems that effect the context menu on Firefox when I switch between desktops

Thanks

Mark