This right-click custom cell menu works when the code is in a workbook.
When placed in an Add-In, it does not work.
I want to use the cell menu for all workbooks.
What am I doing wrong?
(It is saved as an Excel Add-In, and then the Add-In is turned on, this part I know about).
WORKBOOK
MODULE
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by Un-Do Re-Do; 08-05-2017 at 12:20 PM.
The add-in workbook is not activated when it's loaded as an add-in. So use the Workbook_Open event procedure to trigger loading the custom menu.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
@AlphaFrog
Thx very much, it works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks