I have an add-in that contains a simple macro (public sub) that I would like to run when I click a button in the ribbon in Excel 2007. I know how to assign macros and run them in the ribbon, but this is different.
The add-in is password protected. Whenever protection is ON, we can't see the public sub in the list of available macros to assign to a button. When we turn protection off, the sub shows up fine, and we are able to assign it without problems.
How can I assign a button to a macro subroutine that sits inside a protected add-in?