IIF statement to hide a graphic

  • Thread starter Thread starter Bob
  • Start date Start date
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
Access MS Access 2010 IIF statement to check if one date is in or out of range of two other dates (fields) 0
SQL IIF statement with TOP 10 0
iif statements 3
Help with IIF statement in macro 3
Hiding Rows Using IF Statement 1
Multiple iif challenge 2
Access Tricky IIF statement in Access - Grrrr 2

Back
Top