Prev: VB Excel Macro
Next: Stop macro
From: Bob on 3 Mar 2010 16:40
How can I use IIF statement to display or hide a graphic?
From: marcus on 3 Mar 2010 20:09
Hi Bob

If by Graphic you mean a chart. Try this it will hide charts on a
page if a condition is not true.

Take care
Marcus


Option Explicit

Sub VisibleChObj()
If Range("B1").Value = 1 Then
ActiveSheet.ChartObjects.Visible = True
Else
ActiveSheet.ChartObjects.Visible = False
End If

End Sub
 | 
Pages: 1
Prev: VB Excel Macro
Next: Stop macro