[AccessD] Getting error of Ribbon argument

Well Max, that's what I thought too, and I have referenced the Access Object 
Library. I've tried it in Excel too -- the error is rather specific -- says 
the ShowToolbar action isn't available. So, I've tried a number of different 
events -- I get the same error.

There's no need to send you anything, but thanks for offering. In both cases 
I'm working with blank files. In Word and Excel I tried command buttons and 
the appropriate open/close events.

Susan H.


> Once you have set a reference it has "access" to all the code in that
> library so it should work or else throw an error which should be 
> Google'able
> (have I just invented a new word?)
>
> Max
>> 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?