Manipulating custom menubar without MS Office xx Object Library reference

[Alp]

Hi Experts,

Since the commandbarsui seems to be dead, I had to post my question here.

Is it possible to manipulate the .Enabled or .Visible property of a custom
menubar's submenu item through VBA without referencing to Microsoft Office
9.0 Object Library?

Setup is A2K. Apparently there is no CommandBar in any collection within
Access, DAO, VBA and OLE references thus I am unable to use the suggestions
on MS KB or some of the advice I was somehow able to find here.

Any help would be appreciated.

Thanks in advance,

Alp

 

[Alp]

Got it via writing a function based on Marsh's advise to another user.

Thanks

Alp