in reply to Delete a sheet from Excel

The equivalent in VBA to the statement you are looking for is:

Application.DisplayAlerts = FALSE

Set to false before executing code for which you want to skip confirmations. It's a good idea to set it back to true when you are done. :-)


Update: BTW, for anyone wondering, the same basic idea in MS Access is called "SetWarnings".

HTH,

planetscape

Replies are listed 'Best First'.
Re^2: Delete a sheet from Excel
by Anonymous Monk on Sep 12, 2005 at 09:45 UTC
    Thank u very much. it really works. I have one more problem. If I open the file having chart in a new sheet, it pops up a chart menu to customize the chart. Can this also be disabled?
    Thanks once again
[reply]

      That's a good question. Without testing, I'm inclined to think

      Application.ScreenUpdating=False

      might handle that if Application.DisplayAlerts = FALSE doesn't. Try it, if that doesn't work, we'll see if we can't find something else. ;-)

      An offsite reference that may help too is The Spreadsheet Page with its extensive Excel FAQs.

      Good luck, and keep me posted,


      Update: Not sure this would work either, but you might try hiding/unhiding the sheet containing the chart, at least until/unless you want the user to have control over it (i.e., when you are done). Toggle the sheet's Visible property between xlSheetVeryHidden and xlSheetVisible (constants defined below).

      *** Constant Group: XlSheetVisibility
#define xlSheetVisible                                    -1
#define xlSheetHidden                                     0
#define xlSheetVeryHidden                                 2

      [download]

      Update x 2: A couple of other things to try:

      ActiveChart.Deselect de-activates a chart.

      Excel is event-driven. Events may be toggled on/off by setting Application.EnableEvents appropriately.

      planetscape
[reply]
[d/l]
[select]
        I tried it. It didn't help.
[reply]
Re^2: Delete a sheet from Excel
by Anonymous Monk on Aug 07, 2007 at 14:06 UTC
    I would say Yes for MS ACCESS and its DoCmd.SetWarnings... but if you want to take over Excel and really shut down Excel messages you will have to set the "DisplayAlerts" method of your Excel.Application Object to "False" cheers
[reply]
[reply]

In Section Seekers of Perl Wisdom