Question
1
Replies
79
Views
Posted: March 22, 2018
Last activity: April 18, 2018
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***
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.