Welcome to the Monastery | |
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
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).
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
In reply to Re^3: Delete a sheet from Excel
by planetscape
|
|