![]() |
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? |
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? |
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? |
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? |
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? |
All times are GMT +1. The time now is 09:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com