So I am working on a sheet for another group and it has the following code on a worksheet. But the code is not running at all when the sheet is activated.
It was originally just this code:
I updated it to this for testing and I never get a Message Box to pop up:
Any thoughts on what could be causing the code not to run? I click out of the sheet and into another sheet and back again and nothing happens. Just trying to figure out what might be causing this one, seems it should be working to me.
It was originally just this code:
Code:
Private Sub Worksheet_Activate() Call UpdateCodes
End Sub
I updated it to this for testing and I never get a Message Box to pop up:
Code:
Private Sub Worksheet_Activate()ActiveSheet.Unprotect "xxxxx"
MsgBox "It is running"
Call UpdateCodes
ActiveSheet.Protect "xxxx"
End Sub
Any thoughts on what could be causing the code not to run? I click out of the sheet and into another sheet and back again and nothing happens. Just trying to figure out what might be causing this one, seems it should be working to me.