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***
Accepted Solution
Posted: 3 years ago
PEGA
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.