Avatar of Conernesto
Conernesto
Flag 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.
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Subodh Tiwari (Neeraj)

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Subodh Tiwari (Neeraj)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Conernesto

ASKER
Thank you very much.
Subodh Tiwari (Neeraj)

You're welcome!
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck