View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] pfsardella@yahoo.com.nospam is offline
external usenet poster
 
Posts: 172
Default Code to make graph invisible / invisisble

Watch for linewrap (All one line). Toggles visibility on and off.

Sub Tester()
ActiveSheet.ChartObjects("Chart 95").Visible = Not
ActiveSheet.ChartObjects("Chart 95").Visible
End Sub

Tested using Excel 97SR2 on Windows 98SE,

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
Hello:

I am a VERY little bit familiar with VBA and am wondering
if someone can assist me in the code necessary to make a
chart disappear / reappear by clicking a command button.

thanks,

Rick