Question

1
Replies
80
Views
 SHERY WASSEF (SHERYW18)
RBC Royal Bank

RBC Royal Bank
CA
SHERYW18 Member since 2017 6 posts
RBC Royal Bank
Posted: March 22, 2018
Last activity: April 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***

Robotic Process Automation
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.

Accepted Solution

Posted: 3 years ago
Posted: 23 Mar 2018 11:24 EDT
Jeff Badger (jeffbadger)
PEGA
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.