Excel Application version 2000

I have an excel file which is password protected. I have the password but how can I strip or disable excel from asking for a password everytime I open it. Whenever, I uncheck the protect box it still asks for a password. I want to be able to open file without having to enter the password. Do you know of a VB script I can use with the excel file to bypass password protection.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

It's no matter of protection, but security.
- Tools
- Options
- Security
- empty the password fields

SuperFly07Author Commented:
I folowed yur advise and after options I don't see security nor empty the passwords fileds. version 2000 excel
Rory ArchibaldCommented:
From recollection, you need File-Save As, click the Tools option, General Options, clear the Password to Open box.

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

there must be an "security" tab at the top of the options window...
Sorry, I was talking about 2003

- Do a save as
- In the upper right corner select Tools
   - General Options
- In the Save Options box tab to password to open & press delete
  - Tab to Password to modify & press delete
-  OK

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.