• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 183
  • Last Modified:

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.
0
SuperFly07
Asked:
SuperFly07
1 Solution
 
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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now