I know you can reference the different VB windows with VB code - is there
some way to reference the toolbars in the VB Editor window?

Also, the whole, overall window that appears when you enter the VB Editor -
is this the '....VBE.MainWindow'?

--
Bill @ UAMS

"BillCPA" <Bill @ UAMS wrote in message

I know you can reference the different VB windows with VB code - is there
some way to reference the toolbars in the VB Editor window?

Dim objVBE As VBE
Dim cbr As CommandBar
Set objVBE = Excel.Application.VBE
Set bars = objVBE.CommandBars
For Each cbr In objVBE.CommandBars
Debug.Print cbr.Name
Next
Set cbr = objVBE.CommandBars("Menu Bar")
Debug.Print cbr.Name


Also, the whole, overall window that appears when you enter the VB
Editor -
is this the '....VBE.MainWindow'?

Yes
also look at
For Each W in objVBE.Windows

Regards,
Peter T

Application.VBE.CommandBars is the root of all command and menu bars
in the VBA Editor. Yes, Application.VBE.MainWindow is the editor's
main application window.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]




On Thu, 11 Mar 2010 11:07:01 -0800, BillCPA <Bill @ UAMS wrote:

I know you can reference the different VB windows with VB code - is there
some way to reference the toolbars in the VB Editor window?

Also, the whole, overall window that appears when you enter the VB Editor -
is this the '....VBE.MainWindow'?