Password protect exel file

  Marky_Bhoy 18:14 13 Feb 04

I have added a password to some of my excel files in the past but I cannot remember how to do this.

I have Win XP pro and Office XP pro. Basically I want to be prompted for a password every time I open the excel file.

Secondly I would like to know how secure this method would be.

For instance, if someone manged to hack into my PC and took my password protected file then would the only way they would be able to view the contents of the file would be if they knew the password?

  VoG II 18:20 13 Feb 04

Tools/Protection/Protect Workbook.

It is incredibly easy to crack Excel passwords.

  Marky_Bhoy 18:23 13 Feb 04

VoG - I have tried Tools/Protection/Protect Workbook but I am still able to open up the file and VIEW the contents without being prompted for a password.

  Marky_Bhoy 18:26 13 Feb 04

I have just worked out how to do it.

Tools/options/security tab

So how easy is it to crack files that are password protected in this way?

  VoG II 18:29 13 Feb 04

I'm not sure about that password.

The protect workbook and protect worksheet passwords can be cracked by some VBA code that does not take too long to find on the internet.

This thread is now locked and can not be replied to.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Fresh New Fonts of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced