Access 2007 Home Ribbon URGENTLY need to remove

L

Louverril

I know I can remove teh other ribbons using teh Access Opions|Current
Database options. I need to remove the Home ribbon and therefore have no
ribbons ahowing in my application. But I want to remove the whole ribbon for
two reasons

1. The space it takes up.
2. To remove the options from the user.

I can do it by using send keys ctrl F1 but this isn't perfect as if the user
clicked these accidentally the ribbon would reappear.

I have looked at all the microsoft stuff on ribbons and I feel like crying.
Wonderful if you want to really get into it and create a fancy interface. But
can someone just tell me hgow to remove teh ribbon.

Is there a vba command like ribbonhome.visible=false?

Please help - I just can't afford the time to learn all the XML ribbon stuff
at the moment.

Lou
 
A

André Minhorst

Hi Lou,
I know I can remove teh other ribbons using teh Access Opions|Current
Database options. I need to remove the Home ribbon and therefore have no
ribbons ahowing in my application. But I want to remove the whole ribbon for
two reasons

1. The space it takes up.
2. To remove the options from the user.

I can do it by using send keys ctrl F1 but this isn't perfect as if the user
clicked these accidentally the ribbon would reappear.

I have looked at all the microsoft stuff on ribbons and I feel like crying.
Wonderful if you want to really get into it and create a fancy interface. But
can someone just tell me hgow to remove teh ribbon.

Is there a vba command like ribbonhome.visible=false?

Please help - I just can't afford the time to learn all the XML ribbon stuff
at the moment.

if you don't need any ribbon at all you can use the following ribbon
definition:

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="true">
</ribbon>
</customUI>

If you don't know how to applicate this, just look at "all the microsoft
stuff on ribbons". ;-)

Bye
André
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top