Hello -
I am at a loss.
I have an Add-In I created some time ago and recently used Andy Pope's RibbonX Visual Designer in order to add it to my Ribbon. By the way, AJP's RibbonX Visual Designer is AWESOME!!
Anyway, I decided to add a couple of the Add-In commands to the cell menu. Now, when I call these two commands from my custom Ribbon menu, they trigger perfectly. However, if I attempt to use them from the right-click cell menu I get a "Microsoft Visual Basic for Applications Error - Argument not optional." Also, the commands in the cell menu appear and disappear "at will" it seems.
I copied the code from my Add-In into a fresh new workbook to do some troubleshooting and voila! They show up and work just fine - no issues.
Any guesses as to what in the world is going on? Any guidance/help is greatly appreciated.
Thank you.
I am at a loss.
I have an Add-In I created some time ago and recently used Andy Pope's RibbonX Visual Designer in order to add it to my Ribbon. By the way, AJP's RibbonX Visual Designer is AWESOME!!
Anyway, I decided to add a couple of the Add-In commands to the cell menu. Now, when I call these two commands from my custom Ribbon menu, they trigger perfectly. However, if I attempt to use them from the right-click cell menu I get a "Microsoft Visual Basic for Applications Error - Argument not optional." Also, the commands in the cell menu appear and disappear "at will" it seems.
I copied the code from my Add-In into a fresh new workbook to do some troubleshooting and voila! They show up and work just fine - no issues.
Any guesses as to what in the world is going on? Any guidance/help is greatly appreciated.
Thank you.