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.

You shouldn't see that behaviour otherwise no one would ever be able to distribute protected code.

I'm guessing that your users have theier macro security set to high (Tools -> Macro -> Security...) and it should be moderated down to medium or low depending on your attitude to macro risks.

If this is not the answer please could you post back with the exact description of error messages that are popping up etc. as this would make the problem a bit easier to diagnose.

Maccas