Link to home
Create AccountLog in
Avatar of Conernesto
ConernestoFlag for United States of America

asked on

Excel unprotect workbook and make a change to range name

I have an Excel workbook that is protected. The workbook password is AA12. I have a name range called EntityNumber. I need to change the EntityNumber. Is there Excel code that will

1 Allow me to select a workbook from a folder
2 Unprotect the workbook
3 Let me change the EntityNumber
4 Protect the workbook
5 let me save and close the file

Let me know if you need more information. Thank you.
ASKER CERTIFIED SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Conernesto

ASKER

Thank you very much.
You're welcome!