| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB program runs but does not show.
I inherited a spreadshhet (2007) which has a small VB program that updates a
few cells. It is running ut Can no loner see it under the VB window when you click on Visual Basic button on Developer tab in Excel 2007. I had seen it previously, but did somehting and now I can't. How do I view this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VB program runs but does not show.
Hi Fred,
When you open the VBA editor you should see the Project explorer on the left hand side. If you can't then Ctrl/r should display it. The sub headings under Microsoft Excel Objects and under Modules (if any modules) contain the VBA code.Double click to open the code pertaining to these headings. -- Regards, OssieMac "Fred Zack" wrote: I inherited a spreadshhet (2007) which has a small VB program that updates a few cells. It is running ut Can no loner see it under the VB window when you click on Visual Basic button on Developer tab in Excel 2007. I had seen it previously, but did somehting and now I can't. How do I view this? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VB program runs but does not show.
Hey! That worked! Thanks. I still do not know how I "hid" it byt at least I
can see it again! Thanks OssieMac! "OssieMac" wrote: Hi Fred, When you open the VBA editor you should see the Project explorer on the left hand side. If you can't then Ctrl/r should display it. The sub headings under Microsoft Excel Objects and under Modules (if any modules) contain the VBA code.Double click to open the code pertaining to these headings. -- Regards, OssieMac "Fred Zack" wrote: I inherited a spreadshhet (2007) which has a small VB program that updates a few cells. It is running ut Can no loner see it under the VB window when you click on Visual Basic button on Developer tab in Excel 2007. I had seen it previously, but did somehting and now I can't. How do I view this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to NOT show other screens flashing by when macro runs | Excel Programming | |||
| Excel program only runs on one computer | Excel Programming | |||
| show comments when cell is highlighted Vs when cursor runs over? | Excel Discussion (Misc queries) | |||
| show comments when cell is highlighted Vs when cursor runs over? | Excel Discussion (Misc queries) | |||
| Show progress in a user form while code runs | Excel Programming | |||
Linear Mode
