Please help! I am using BeforeRightClick to run some code in Excel 2003 VBA
(XP Professional), and setting Cancel=True to disable the default drop down
menu. This works fine when I am working in the .xls worksheet in which the
code resides, but when I try to implement the sheet as an .xla addin, the
code never executes and the default cut.copy, paste etc. menu is all I get.
It doesn't appear to matter if I place the code in the Workbook or Worksheet
regions, or make it public or private, or anything else I have tried. Getting
frustrated!

Any suggestions or work-arounds would be most welcome.