Constant data appearing in Immediate Window of VBE

  • Thread starter Thread starter JMay
  • Start date Start date
J

JMay

Somehow the below constantly appears in my VBE Immediate window:
How can I erase it so that the window is "clean"?
I just loaded my book.xlt and erased it and resaved book.xlt. Then Closed
Excel
Reopened Excel and Alt-F11 Ctl-G and there is again...??????
TIA,


[auto_open] <
[SetupFunctionIDs] <
[SetupFunctionIDs] >
[PickPlatform] <
[PickPlatform] >
[VerifyOpen] <
[VerifyOpen] > 1
[RegisterFunctionIDs] <
[RegisterFunctionIDs] >
[auto_open] >
 
It looks like debug code to me that is being written to the immediate window
in Debug.Print statements. Each sub prints its name at the start probably.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
So is there a way of "getting rid of it"?
TIA

Bob Phillips said:
It looks like debug code to me that is being written to the immediate window
in Debug.Print statements. Each sub prints its name at the start probably.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

JMay said:
Somehow the below constantly appears in my VBE Immediate window:
How can I erase it so that the window is "clean"?
I just loaded my book.xlt and erased it and resaved book.xlt. Then Closed
Excel
Reopened Excel and Alt-F11 Ctl-G and there is again...??????
TIA,


[auto_open] <
[SetupFunctionIDs] <
[SetupFunctionIDs] >
[PickPlatform] <
[PickPlatform] >
[VerifyOpen] <
[VerifyOpen] > 1
[RegisterFunctionIDs] <
[RegisterFunctionIDs] >
[auto_open] >
 
You're loading the Analysis Toolpack Addin (VBA) - atpvbaen.xla.
Recent versions of that add-in apparently didn't have this debugging
code removed. It's mostly harmless.
 

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

Back
Top