View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default SheetBeforeRightClick stops firing if macro populates data

Something to look for would be that you set application.enableevents to false
and then don't turn it back on again. At that point no events will be firing
and your double click will not register. Other than that you need to post
some code so we can see what you are talking about...
--
HTH...

Jim Thomlinson


"MAB" wrote:

The SheetBeforeRightClick event I created works initially when I open the
workbook but if I (with a macro) clear all the data (except header row) then
repopulate with new data, SheetBeforeRightClick stops firing? Any ideas why?