View Full Version : hiding ribbons
philfer
05-18-2010, 12:54 PM
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
05-18-2010, 01:19 PM
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
philfer
05-19-2010, 10:51 AM
Hi xld,
Just a longshot but do you know if there is an equivalent for Access
thanks
phil
Paul_Hossler
05-19-2010, 12:38 PM
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.