Password protect exel file

  Marky_Bhoy 18:14 13 Feb 2004

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 2004

Tools/Protection/Protect Workbook.

It is incredibly easy to crack Excel passwords.

  Marky_Bhoy 18:23 13 Feb 2004

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 2004

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 2004

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.

Elsewhere on IDG sites

Honor 9 Lite review

How Social Media has Propelled Political Graphic Design and Art in the Last Decade

The best kids apps for iPhone & iPad 2018

HomePod d’Apple : date de sortie, prix et fiche technique