Results 1 to 6 of 6

Worksheet Change Event to Show Command Button

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-16-2010
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    278

    Worksheet Change Event to Show Command Button

    I can't get this to work, any guidance? If the target is not blank (it starts out blank, then show the button. (I've reworked this in multiple ways and can't come up with the correct language)

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    
    If Not Intersect(Range("Approved"), Target) Is Nothing Then
            If Not Range("Approved") = "" Then
                    cbtEmailMgr.Visible = True
        End If
        
    End If
    
    End Sub
    Thanks!
    Last edited by ker9; 03-21-2011 at 04:36 PM.

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