ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   macro that doesn't work... (https://www.excelbanter.com/excel-programming/292784-macro-doesnt-work.html)

VILLABILLA[_3_]

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


Bob Phillips[_6_]

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