[SOLVED:] How to hide default ribbon in Access 2010 [Archive]

View Full Version : [SOLVED:] How to hide default ribbon in Access 2010

winxmun

11-03-2015, 08:42 PM

Hi,
May I know how to hide the default ribbon in Access 2010 when user open the Access File (to prevent other user from changing the tables, queries, forms & etc). However the Add-Ins manually created by user must be displayed. I've attached the screenshot in the attachment for reference.

winxmun

11-04-2015, 03:53 AM

Hi, I've found the solution after google a day...this is the link https://desmondoshiwambo.wordpress.com/2012/07/09/how-to-hide-the-ribbon-in-microsoft-access-using-the-usysribbons-table/

HiTechCoach

11-04-2015, 07:48 PM

Thanks for sharing your solution for hiding the Ribbon.

Hi,
...(to prevent other user from changing the tables, queries, forms & etc).

ALERT: Just hiding the ribbon will not prevent user from changing the tables, queries, forms & etc.

I prevent other users from changing the tables, queries, forms & etc and never have to hide the Ribbon. It is wise to create a custom Ribbon to provide a good UX.