Am I killing the event when I exit the sub? Meaning, if you click a cell and the Target.Value > 0 it works as it should, but the second a cell is clicked and the Target.Value = 0 the Debug.Print line is no longer hit, and the Sub is no longer called when a cell is clicked where Target.Value >= 1 w/o closing and reopening the workbook.
Should this be set-up differently?
Please Login or Register to view this content.
Hi,
Nothing there is disabling events. Do you have any other event code?
Don
Please remember to mark your thread 'Solved' when appropriate.
Grr.....it's never that easy, haha. Below is yntax I am running.
Please Login or Register to view this content.
There is also nothing in that code to disable events. Do you have any other event code?
No sir - that is all the code.
Can you post a workbook in that case?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks