Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't see Modules and Worksheets in VBE
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't see Modules and Worksheets in VBE
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't see Modules and Worksheets in VBE
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't see Modules and Worksheets in VBE
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. "Barb Reinhardt" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't see Modules and Worksheets in VBE
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't see Modules and Worksheets in VBE
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 "Bassman62" wrote: 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. "Barb Reinhardt" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My VBA Project Explorer quit listing modules and worksheets separa | Excel Programming | |||
Public, Private, Event modules, Forms modules,,, | Excel Programming | |||
Basic question - modules and class modules - what's the difference? | Excel Programming | |||
When to code in sheet or userform modules and when to use modules | Excel Programming | |||
Class Modules vs Modules | Excel Programming |