View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
fatfish[_4_] fatfish[_4_] is offline
external usenet poster
 
Posts: 1
Default How2 Delete "Not exist" charts/sheets?

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