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.
--
Regards,
OssieMac
"Barb Reinhardt" wrote:
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
"OssieMac" wrote:
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.
--
Regards,
OssieMac
"Barb Reinhardt" wrote:
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