Upgrade to 2003, strange stuff in Immediate Window

[salgud]

Just upgraded to 2003 (I know, I work for the state), and now I'm seeing
the following "stuff" in the Immediate Window when I first open the VBE

[SetupFunctionIDs] >
[PickPlatform] <
[PickPlatform] >
[VerifyOpen] <
[VerifyOpen] >

Is this useful somehow? If so, what does it mean?
Thanks in advance.

 

[Bob Phillips]

It is some debugging code that the MS developers left in the VBA Analysis
Toolpak addin.

 

[Mike H]

Hi,

It's all debug code form the analysis toolpak VBA addin. AFAIK it's debug
messages that should have been removed.

The < means process started
the > means process finished

Mike

 

[dave glynn]

I have a vba procedure that deletes "n" number of sheets; every time it
deletes one it forces me to respond manually to confirm if i want to go ahead
with the deletion.

Once the procedure is completed with nw information i want to save the file;
again I'm forced to intervene to confirm.

How can i avoid these interventions/

With thanks

Dave

 

[salgud]

Thanks to both of you.

 

[Susan]

near the beginning of your procedure enter:
Application.DisplayAlerts = False

and near the end:
Application.DisplayAlerts = True

hope that helps

susan

 

[Gord Dibben]

Application.DisplayAlerts = False
Delete the sheets
Save the file
Application.DisplayAlerts = True


Gord Dibben MS Excel MVP