[AccessD] Getting error of Ribbon argument

Hi Susan,

For Excel 2007 you can use the follow code (from Ron DeBruin)

'======================================================================
Sub HideRibbon()
    Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
End Sub


Sub ShowRibbon()
    Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"
End Sub
'========================================================================

For other tweaking tips in Excel have a look here
http://www.rondebruin.nl/ribbon.htm

Cheers
Darryl.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Thursday, 2 April 2009 3:38 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Getting error of Ribbon argument

I can't recall ever using DoCmd in anything but Access -- and as part of the 
Access object model, it would makes sense that it isn't available to other 
applications, but thought I'd try.

I've spent a little time in both Excel and Word's VBA Help and can't find 
anything helpful on hiding the ribbon -- even the Object Browser turns up 
nothing. Well, it turns up stuff, just nothing I could use.

Surely you can hide the ribbon programmatically in Word and Excel?

Susan H.


> Hi Susan,
> I don't know the answer but if you set a Reference to Microsoft Access 12
> Object Library then it will probably compile ok.
>
> Whether it works or not is another matter
>
> hth

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

This email and any attachments may contain privileged and confidential information
and are intended for the named addressee only. If you have received this e-mail in
error, please notify the sender and delete this e-mail immediately. Any
confidentiality, privilege or copyright is not waived or lost because this e-mail
has been sent to you in error. It is your responsibility to check this e-mail and
any attachments for viruses.  No warranty is made that this material is free from
computer virus or any other defect or error.  Any loss/damage incurred by using this
material is not the sender's responsibility.  The sender's entire liability will be
limited to resupplying the material.