Short version: I am attempting to find the language to execute a macro the first time the right mouse button is pressed by the user. It needs to execute only once per instance of the file being open. Below is the long version of my issue:)
I am attempting to assign a macro to a drop down box, but I'm having a strange issue. We are using third party software to publish data through Excel to the internet, so I assume this is causing the issue. Issue -->The drop down box is populated by a named range, but the range fails to expand and contract properly when the macro is assigned to the box. Is there a creative way to assign the macro to the drop down box after the first click of the mouse by the user? I know how to use a seperate macro to assign the main macro, but what would the trigger language be? I would only want it to assign once per instance of opening the spreadsheet, but not necessarily upon opening, as the third party software is populating data and there could be a conflict. I wouldn't want a button either, as I would prefer a cleaner look.
Thanks for any help!