| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why there is a blank "book 1" sheet pops with all workbooks?
Every time I open an old or current "workbook", a blank/additional sheet,
"book 1", also loads in the back. This was not the case before a "QI Macro" was added to my station (PC). Does anyone knows why that is happening and/or how can I turn it off? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
why there is a blank "book 1" sheet pops with all workbooks?
post the code in this macro and we'll translate it for you
"Frank R" wrote: Every time I open an old or current "workbook", a blank/additional sheet, "book 1", also loads in the back. This was not the case before a "QI Macro" was added to my station (PC). Does anyone knows why that is happening and/or how can I turn it off? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
why there is a blank "book 1" sheet pops with all workbooks?
How can I check what the Macro "code" is, so I could post it for you to see?
"Duke Carey" wrote: post the code in this macro and we'll translate it for you "Frank R" wrote: Every time I open an old or current "workbook", a blank/additional sheet, "book 1", also loads in the back. This was not the case before a "QI Macro" was added to my station (PC). Does anyone knows why that is happening and/or how can I turn it off? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
why there is a blank "book 1" sheet pops with all workbooks?
press Alt-F11 to bring up the Visual Basic Editor (VBE)
In the top left corner you should see a listing of all the open workbooks Expand each workbook and double-click on the names of all the subordinate objects. When you see text appear in the right hand panel, that will be the macro "Frank R" wrote: How can I check what the Macro "code" is, so I could post it for you to see? "Duke Carey" wrote: post the code in this macro and we'll translate it for you "Frank R" wrote: Every time I open an old or current "workbook", a blank/additional sheet, "book 1", also loads in the back. This was not the case before a "QI Macro" was added to my station (PC). Does anyone knows why that is happening and/or how can I turn it off? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
why there is a blank "book 1" sheet pops with all workbooks?
I may be missing something; when I follow your info below, the VBE does not
show any listings, the window is "blank" even after opening various Excel documents. Sorry, I am not to familiar with Excel. "Duke Carey" wrote: press Alt-F11 to bring up the Visual Basic Editor (VBE) In the top left corner you should see a listing of all the open workbooks Expand each workbook and double-click on the names of all the subordinate objects. When you see text appear in the right hand panel, that will be the macro "Frank R" wrote: How can I check what the Macro "code" is, so I could post it for you to see? "Duke Carey" wrote: post the code in this macro and we'll translate it for you "Frank R" wrote: Every time I open an old or current "workbook", a blank/additional sheet, "book 1", also loads in the back. This was not the case before a "QI Macro" was added to my station (PC). Does anyone knows why that is happening and/or how can I turn it off? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
| If A3=alpha numeric,"X", if A3=text,"Y", Blank | Excel Worksheet Functions | |||
| How to fill in "BLANK" Cells Automactically...Large Spread Sheet | Excel Discussion (Misc queries) | |||
| Removing the "broom" that pops-up in Excel | Excel Discussion (Misc queries) | |||
| Changing "returned" values from "0" to "blank" | Excel Worksheet Functions | |||
Linear Mode
