Hide Ribbon in Access 2007

  • Thread starter Thread starter sherwinb
  • Start date Start date
S

sherwinb

Hi,

I used the following code successfully in Access 2003 to hide the menu bar
on a form's OnLoad property:

Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i

What code should I use to hide the ribbon in Access 2007 and can I combine
the code so that the ribbon or menu bar is hidden depending on if the user
has Access 2003 or 2007?

Thanks
 
You can't hide the ribbon completely. You can adjust it by making a table
filled with xml and setting this to the database.

For examples on this look at: www.accessribbon.de

When using two versions you have to take into consideration that the ribbon
and menu's are totally different from each other. If you do need to make a
check you also have to provide a table with the xml inside it.

hth
 
Have a look at my post and thread (dated 02/09/08) in
microsoft.public.access.commandbarsui for a possible answer to your problem.
You may need to do version checking regarding Access 2k3 or 2k7.
Regards
 
Back
Top