cannot insert OLE command button event code
I dynamically added an OLE command button, and also its corresponding event code to an excel sheet. My VBA project is password protected. The code works fine if I log into my VBA project first. But for the users, they don't need to log into the VBA project, and they don't know the password either. The code cannot be run due to the protected status.
Is there a way I can work out this situation? How can I pretend to be the superuser in the VBA code to insert the event code?
Please advice. Thanks.