Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheet change event doesn't work
I have the following simple code for example reasons. For some reason,
when the range "attn" is changed, the macro won't operate. Here is the simple code I have: Private Sub Worksheet_Change(ByVal attn As Excel.Range) Application.EnableEvents = False MsgBox "hello" Application.EnableEvents = True End Sub There is code to be inserted where the msgbox is. Any suggestions are greatly appreciated. Thank you, Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Change event | Excel Discussion (Misc queries) | |||
Change event fails to work | Excel Worksheet Functions | |||
Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming | |||
worksheet change event | Excel Programming | |||
Worksheet change event | Excel Programming |