Results 1 to 8 of 8

Combine 2 worksheet change events

Threaded View

  1. #1
    Registered User
    Join Date
    05-22-2012
    Location
    Birmingham, UK
    MS-Off Ver
    Excel 2010
    Posts
    41

    Combine 2 worksheet change events

    Hi

    I am trying to combine two worksheet change events without any joy;

    Private Sub Worksheet_Change(ByVal Target As Range)
    If [l7] = "Yes" Then
    Sheets("Mobile Tower checklist p10").Visible = True
    Else
    Sheets("Mobile Tower checklist p10").Visible = False
    End If
    Private Sub Worksheet_Change(ByVal Target As Range)
    If [l6] = "Yes" Then
    Sheets("LIFT PLAN").Visible = True
    Else
    Sheets("LIFT PLAN").Visible = False
    End If
    End Sub
    Im sure its a fairly simple fix but im baffled!

    cheers
    Last edited by Cutter; 09-07-2012 at 06:55 PM. Reason: Added code tags

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