| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| drop down list populates data in another cell | Excel Discussion (Misc queries) | |||
| Type data in one cell - and it automatically populates another cel | Excel Worksheet Functions | |||
| Macro not firing off | Excel Programming | |||
| Trap SheetBeforeRightClick event from another workbook | Excel Programming | |||
| Event sometimes stops firing? | Excel Programming | |||
Threaded Mode
