Platform independent code to hide the 2007 ribbon

[anubis2k11]

Hi,

I'm looking for a way to hide the ribbon in access 2007.

this website

http://www.tech-archive.net/Archive...ic.access.modulesdaovba/2008-12/msg00937.html

has a method to hide the ribbon. The sendkeys statement works, but the test to see if the ribbon is hidden or not (fReturnRegKeyValue) uses a registry key. This is fine if you are installing on a single OS, but I will be installing my app on Win7, xp and 2003. Consequently the registry is different on each os, and I'd like a method that has a test that's platform indenpendent.

Any ideas? Thanks.

 

[StarPassing]

To hide the ribbon:

DoCmd.ShowToolbar "Ribbon", acToolbarNo

To unhide it:

DoCmd.ShowToolbar "Ribbon", acToolbarYes

 

[kjv1611]

A couple of notes:
1. SendKeys should only be used as a last result for anything, as it can be QUITE messy. And since you would want to put the code in VBA, which is within the Office application, it'd not make sense to "send" anything out of the application, to have it return an action to the same application.
2. Anything that updates the registry for any sort of fixes is bound to end up being problematic assuming this is installed on ANY machines that have user-level privileges in Windows. Even at Admin level, login-scripts will often disbable access to the registry.

Let us know how StarPassing's suggestion works - it looks correct, I've just never tried it. I might sometime soon, though.