hiding ribbons

[philfer]

Hello,

Is there a way to programatically hide all the ribbons and the ribbon tabs

I have a macro with a dashboard page and dont want the user to use the ribbons

Thanks
Phil

[Bob Phillips]

Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"

[philfer]

Hi xld,

Just a longshot but do you know if there is an equivalent for Access

thanks
phil

[Paul_Hossler]

ref: http://www.vbaexpress.com/forum/showthread.php?t=31899

You can customize the Custom UI XML associated with a XLSM file to completely hide the ribbon. Post #10 has a small "Hello World" XLSM

Paul