![]() |
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 |
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/ |
All times are GMT +1. The time now is 09:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com