View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default Dim as CommandBar Does not Work

Omar,

The commandbars are part of the Microsoft Office ? Object Library.

In the VBE, use Tools | References.... and put a check next oto Microsoft
Office ? Object Library. The ? will be 11 for Office 2003, IIRC.

HTH,
Bernie
MS Excel MVP

"Omar" wrote in message
...
Hi there,

I'm trying to add a new menubar with menu items and i was trying to use

one
of the procedures that I found in Excel 2002 VBA but it does not seem to

work
for some reason. In that procedure you should define one of your

variables
as command bar:

dim xxx as CommandBar

And for some reason it does not seem to work with me, VBA does not seem to
recognize the CommandBar type of objects.

Does this mean that I have incomplete installation of VBA or there is a

bug
with Office 2003 that I'm using. Or, microsofy has deleted CommandBar

type
of objects from its VBA code.

Can anybody help me with that.

Regards