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.
SuperFly07Asked:
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.

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

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

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

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

- 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

Bob
0
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.