I have an excel which is written by some other organization and macros are in place in this excel.
The excel has User form/ Controls and excel is password protected. I do not have password for this excel.
When user selects the various values from drop down or enters the numbers and click on submit button, various macros fire in the background and provides calculated results.

I can use this excel manually.

Now the ask is to do this task repetitively for 100+ tasks on daily basis.

Can I write a macro to access this protected excel and do automation.