Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 SHERY WASSEF (SHERYW18)
RBC Royal Bank

RBC Royal Bank
CA
SHERYW18 Member since 2017 6 posts
RBC Royal Bank
Posted: Mar 22, 2018
Last activity: Apr 18, 2018
Posted: 22 Mar 2018 12:23 EDT
Last activity: 18 Apr 2018 14:02 EDT
Closed
Solved

Excel VBA Unprotect InputBox

Hi!

I am trying to make Pega run a macro that is to un-protect the workbook which requires a password entry (password for project).

How can I make it enter password into the input box?

Any help would be great!

***Edited by Moderator Marissa to update categories***

To see attachments, please log in.
Robotic Process Automation

Accepted Solution

Posted: 6 years ago
Posted: 23 Mar 2018 11:24 EDT
Jeff Badger (jeffbadger)
PEGA
Principal Product Manager, Robotics
Pegasystems Inc.
US

Change the macro to accept and input parameter for the password.  Collect the password using a supported method (form, ASO Manager, etc.) and pass it to the macro.  There should be a method available in VBA to unprotect the workbook without an input box required.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice