| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Upgrade to 2003, strange stuff in Immediate Window
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Upgrade to 2003, strange stuff in Immediate Window
It is some debugging code that the MS developers left in the VBA Analysis
Toolpak addin. -- __________________________________ HTH Bob "salgud" wrote in message . .. 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Upgrade to 2003, strange stuff in Immediate Window
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 "salgud" wrote: 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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
automatic confirmation of delete etc
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Upgrade to 2003, strange stuff in Immediate Window
Thanks to both of you.
|
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
automatic confirmation of delete etc
near the beginning of your procedure enter:
Application.DisplayAlerts = False and near the end: Application.DisplayAlerts = True hope that helps :) susan On Jan 15, 1:27*pm, dave glynn wrote: 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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
automatic confirmation of delete etc
Application.DisplayAlerts = False
Delete the sheets Save the file Application.DisplayAlerts = True Gord Dibben MS Excel MVP On Thu, 15 Jan 2009 10:27:03 -0800, dave glynn wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I upgrade to 2003 | Excel Discussion (Misc queries) | |||
| Strange window behavior | Excel Programming | |||
| Strange window behavior | Excel Programming | |||
| Strange window behavior | Excel Programming | |||
| Strange code showing up in Immediate Window | Excel Programming | |||
Linear Mode
