[AccessD] Getting error of Ribbon argument

Thanks Darryl, I'll give it a try!

Susan H.


> 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.
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com