Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
why, when i open a work sheet does a blank sheet open as well
any answers?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
why, when i open a work sheet does a blank sheet open as well
More details?
"John" wrote: any answers? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
why, when i open a work sheet does a blank sheet open as well
You might want to try the reverse of this, when you get to the Objects,
delete the code if it exists John From Excel, hit Alt-F11 to open the VBE. On the left side is the Project Explorer. One of the project listed should be Personal.xls. Expand the project if necessary and open the folder called Microsoft Excel Objects. In that folder, there is an object called ThisWorkbook. Double click that and it will open a code pane for that module. At the top of that code pane, there are two drop down boxes. From the left one, select Workbook and from the right select Open (it may select that for you automatically). This will put the Sub and End Sub statement in the code pane. You type in the rest of the code. The ThisWorkbook module is actually a special kind of Class Module. It already has all the class information coded into it, so you have access to all of the events. "John" wrote in message ... any answers? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I open Excel I want it to open on Sheet 1 | Excel Discussion (Misc queries) | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
How to open a work spreed sheet | Excel Worksheet Functions | |||
Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) | |||
open at define work sheet | Excel Discussion (Misc queries) |