ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   why there is a blank "book 1" sheet pops with all workbooks? (https://www.excelbanter.com/excel-worksheet-functions/152923-why-there-blank-book-1-sheet-pops-all-workbooks.html)

Frank R

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?

Duke Carey

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?


Frank R[_2_]

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?


Duke Carey

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?


Frank R[_2_]

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