Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Delete all sheets in workbook that contain "Dump" in the name | Excel Worksheet Functions | |||
User Defined Charts-Missing the "Add-Delete" Options. | Excel Discussion (Misc queries) | |||
User Defined Charts-Missing the "Add-Delete" Options. | Excel Discussion (Misc queries) | |||
How do I delete Sheets if "Delete" is greyed out? | Excel Discussion (Misc queries) | |||
Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc | Excel Programming |