Hi all,
I created the macro to delete charts..
Also I add a button to the menu and wanna click the button
to delete all the used charts.
The problem is: I wanna use one button to "clean" ALL the "used
charts,
but some of those charts may not exist (because I use different macr
to
create different charts), so Excel can not find them and will ask me t
debug.
e.g.
Sheets("Chart TC123").Select
ActiveWindow.SelectedSheets.Delete
and "Chart TC123" doesn't exist!
How to avoid the error message
--
Message posted from
http://www.ExcelForum.com