Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro that doesn't work...
Sub delchart()
' ' delchart Macro ' Macro recorded 27.2.2004 by Registered User ' ActiveSheet.ChartObjects(1).Visible = False ' End Sub About above showned macro; does it say to delete any ChartObject tha is active or a a certain chart in particular? I need a line that says to delete any chart that is on my sheet. Ca someone help me with this one because above mentioned line doesn't wan to work, maybe I do something wrong? Thanks -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro that doesn't work...
See my answer in .Misc. If you want to hit many groups, do it with one post,
don't post many times. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "VILLABILLA " wrote in message ... Sub delchart() ' ' delchart Macro ' Macro recorded 27.2.2004 by Registered User ' ActiveSheet.ChartObjects(1).Visible = False ' End Sub About above showned macro; does it say to delete any ChartObject that is active or a a certain chart in particular? I need a line that says to delete any chart that is on my sheet. Can someone help me with this one because above mentioned line doesn't want to work, maybe I do something wrong? Thanks, --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to sum doesn't work | Excel Discussion (Misc queries) | |||
Macro will not work - Please help | Excel Discussion (Misc queries) | |||
Macro to update a column in a work based on another work sheet | New Users to Excel | |||
Macro works Macro does not work | Excel Discussion (Misc queries) | |||
Why Won't This Macro Work? | Excel Discussion (Misc queries) |