in reply to Re: Delete a sheet from Excel
in thread Delete a sheet from Excel

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

Replies are listed 'Best First'.
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

    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
      I tried it. It didn't help.