running a macro on protected worksheet

Alright, this one is kind of out there. We have a spreadsheet at work that is protected by the person who created it. It has a bunch of macros embedded that we can use to do certain tasks. I am working on a different spreadsheet that I was trying to automate to pull data from the protected sheet. The problem is since it's protected, I can't access the macro code. I'm wondering if there is any way to utilize a user interface in my VBA. So I know that when I am just clicking around I can click the button to run "macro 1" and it gives me the output I need. So is there any way to just tell it to run "macro 1" and get the input to use in my code? I will try to preempt a few questions. First, the macro I want to use is way too complicated for it to be worth me trying to just recreate it in my own code. I either use his macro or I can't automate it. Second, assume I cannot under any circumstances get the password and/or the code for the macro. If I can do it, it has to be done entirely from my end. I'm not optimistic about this, but I'm hoping some of you wizards out there still have something up your sleeve... Thanks in advance for any help.

==========
MODERATOR's WARNING:
This thread is being monitored due to Forum Rule #11 (please read the Forum Rules, link above in the menu bar). Any attempts by anyone to circumvent Excel or workbook security will be moderated.

This code will call a macro in another workbook. It will work even if the VBA code in the other workbook is password protected.

Please Login or Register  to view this content.