why there is a blank "book 1" sheet pops with all workbooks?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
How can I check what the Macro "code" is, so I could post it for you to see?
 
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Collapsing all groups 0
Pop up verification when opening a sheet. 5
Insert Incremental sheet names in a workbook 2
macro to sum select columns in all workseets within a workbook 2
Insert a new Worksheet AFTER the existing (Active) sheet 1
Excel Populate workbook A from Data in workbook B based off criteria in Workbook C 0
Fix multiple 'assign macro' references broken due to moving sheet 1
Problem with shared workbook (history sheet) 2

Back
Top