whats the difference?

  • Thread starter Thread starter majikman
  • Start date Start date
M

majikman

Whats the difference between using ActiveWorkbook.CommandBars
Application.CommandBars, Excel.CommandBars??
 
A good place to do your homework might be the vbe help file.
alt F11 to goto the vbe>f1 to goto help> use index for commandbars
 
Commandbars are a collection within the Application object. Normally, when
working within VBA in an Excel application, you don't need the Application
object qualifier, but many posts have reported problems with commandbars
that have been solved by using Application.Commandbars.

As for Activeworkbook.Commandbars, never seen that one, doesn 't seem to
work for me.

Excel.Commandbars is just the same as Application.Commandbars, except you
can't use it in Word?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disable Menu Items 2
Diable a macro after use 1
Totally Disabling (^ save ) (Save as) and Save Icon – Which code do I use: 8
hide formula bar (and menu bar etc) 2
auto enable macros 5
Stripping down excel 2
Trying to close without the message do you want to save 1
Workbook_close 1

Back
Top