See this page Carl
http://www.rondebruin.nl/ribbon.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Carl Hartness" wrote in message oups.com...
The real solution seems to be to create a customUI.xml file containing
<ribbon startFromScratch="true" / and incorporate it into the Excel
file. I have the customUI.xml created, but can't figure out how to
incorporate it. I tried opening the Excel file with PKZIP and adding
it, but it probably needs a subfolder.

Anybody know how to incorporate customUI?

On Mar 5, 4:13 am, "Carl Hartness" wrote:
On Mar 1, 5:00 pm, "Ron de Bruin" wrote:





Never try this (add it to my list with things to do)

Here is a example from Jim Rech to hide the ribbon

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

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

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"Carl Hartness" wrote in glegroups.com...
On Excel 2003, my client's spreadsheet used
Application.DisplayFullScreen= True. According to the
DisplayFullScreenhelps, thatappropriatelyhidestheapplication
titlebar. With 2007, it no longer does, which changes the appearance
to his users. I don't find another 2007applicationobject property
which applies. Perhaps thetitlebarhas gone to an xml
implementation similar to the ribbon. Can anyone help?- Hide quoted text -

- Show quoted text -

Hi Ron, thanks for the suggestion.

It seems odd to invoke an Excel4Macro in Excel 12.0, but they do
indeed hide and unhide the ribbon. This will be handy in the future,
since the macro recorder doesn't record anything when hiding the
ribbon from "Customize Quick Access Toolbar" dropdown on thetitlebar. Unfortunately, I am trying to hide thetitlebarand caption.

I made some guesses, substituting Caption and TitleBar for Ribbon, but
didn't stumble upon anything.

Carl.- Hide quoted text -

- Show quoted text -