Using BeforeRightClick in addins

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Tom,

You da man! I went to the recommended link and was up and running in 15
minutes. Consider my hat respectfully tipped...

HubbaBubba
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to trigger code in Excel add-in after double-click or right-cl 2
COM addin won't connect when workbook opened via another workbookfrom another instance 3
Handling Worksheet Events of a Worksheet Created During Runtime. 1
Relocating my AddIn 3
Avoid protected cell warning on BeforeDoubleClick WS event 2
macros in my custom xla Addin - how to make visible in Macro menu? 2
Folder location for Addins 9
.XLA: Making it an AddIn vs adding a Reference? 24

Back
Top