Re: 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

Comment on Re: Delete a sheet from Excel Download Code

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]
Re^3: Delete a sheet from Excel by planetscape (Chancellor) on Sep 12, 2005 at 10:00 UTC
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]
Re^4: Delete a sheet from Excel by Anonymous Monk on Sep 12, 2005 at 10:25 UTC
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]
Re^3: Delete a sheet from Excel by planetscape (Chancellor) on Aug 07, 2007 at 19:46 UTC
As I stated in Re: Delete a sheet from Excel, yes? HTH, planetscape	[reply]


Just another Perl shrine
	PerlMonks