Results 1 to 3 of 3

Display/Hide chart

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    858

    Display/Hide chart

    I have four check boxes that each respond to code when checked. Different fields are displayed in a pivot chart. I want to display a chart when check box 4 is TRUE and hide the chart when any of the other check boxes are true. The code I am using is not working correctly?
    Dim ChtObj As ChartObject
        Set ChtObj = ActiveSheet.ChartObjects(1)
            If Range("Trigger12") = True Then
                ChtObj.Visible = False
            If Range("Trigger3") = True Then
                ChtObj.Visible = False
            If Range("Trigger2") = True Then
                ChtObj.Visible = False
        Else
                ChtObj.Visible = True
        End If
        End If
        End If
    Thanks in advance
    Last edited by Aland2929; 02-17-2012 at 11:28 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1