Results 1 to 8 of 8

Private sub worksheet_change not working

Threaded View

  1. #1
    Registered User
    Join Date
    10-08-2010
    Location
    North Yorkshire, England
    MS-Off Ver
    Excel 2003
    Posts
    69

    Private sub worksheet_change not working

    Hello
    I'm having trouble with a worksheet change code. No problem with this type of code elsewhere in the workbook but on this particular sheet it is not playing ball.

    Code as follows:

    Private Sub Worksheet_Change(ByVal Target As Excel.Range)
        
        If Target.Address = "$c$4" Then
        
        Call Auth
       
        End If
         
    End Sub
    Nothing happens if I change cell C4. If I disable that line then the Auth macro is called if I change any cell (including c4 which is a drop-down list) in the offending worksheet. Have run
    Application.EnableEvents = True
    in a separate macro but still no joy.

    Any help, as always, much appreciated
    Last edited by arlu1201; 03-19-2013 at 07:44 AM. Reason: Replaced php tags with 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