Can't see Modules and Worksheets in VBE

[Barb Reinhardt]

I've just migrated to Office 2007 in the last 2 weeks and now when I go into
the VBE, I can't see the list of Modules and Worksheets in the VBE. I've
looked at all settings there, but can't find something that makes sense to
change.

Thanks,
Barb Reinhardt

 

[OssieMac]

Hi Barb,

While in the VB editor Ctrl/r turns on Project Explorer. Alternatively
select menu item View -> Project Explorer.

You might already know this but you also need Developer tab in Ribbon in the
Excel worksheet. To turn this on:-

Click Microsoft button (large button top left of screen)
Select Excel options (Towards bottom right of dialog box)
Select Popular (Left column. It is default with Options)
Check Show Developer tab in Ribbon.

 

[Barb Reinhardt]

I have the developer Tab enabled (already did) and tried to display the
Project explorer and NOTHING. I've even toggled the Developer Tab off and
back on and nothing. Any other ideas?

Barb Reinhardt

 

[Bassman62]

Barb,

It could be that the Project window was inadvertently made very narrow with
the slip of the mouse. I was able to "hide" the project window in this way.

On my machine, the Project window defaults to the left window pane. Try
hovering your mouse near the left edge of the vbe window and at the first
'double bar-arrow' <-||-> , click and drag to the right.

Hope this helps.

 

[OssieMac]

Hi Barb,

When I replied I wondered if there was something else amiss because I was a
little surprised with an experienced Excel person asking that sort of
question.

Anyway it appears that something else is amiss. I am only clutching at
straws with the following suggestions.

Have you got a complete installation and not just a partial tryout
installation? Can you insert a module and then some simple code like a MsgBox
and run it successfully? In the View Menu is Project Explorer visible and
enabled?

Check that the Project Explorer window is not Hidden by reducing in width.
Can check by moving cursor towards left of screen and look for vertical
parallel lines with horizontal arrows both sides for dragging out the width.

Can't think of any other suggestions but hope that you get it working.

 

[Barb Reinhardt]

Found it ! I resized the VBE window and saw something odd over the toolbar.
When I resized it, it was back. This has happened a couple of times and I'm
not sure why it's happening. If it's a problem for someone with some
experience, how will new users manage?

Thanks again,
Barb Reinhardt