jacksonm1234
asked on
Can't add protected add-in macro to ribbon
Hi everyone.
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?
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?
How about customizing the addin to provide you with a menu option in the addins ribbon?
Read on, and advise if you need further assistance.
http:/Q_26837274.html
Dave
Read on, and advise if you need further assistance.
http:/Q_26837274.html
Dave
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry to neglect my question!
This solution worked great. We implemented it immediately and worked as expected. THANK YOU!
This solution worked great. We implemented it immediately and worked as expected. THANK YOU!
I would try to turn off protection, assign it as you desire.
save the workbook, turn on protection, save it again and close the workbook.
try to re-open it and test the button.
Thanks