lock xl file with pass

[hal9000]

is there any way to lock an xl file with passwords that
you could set on your own as so in this case would be able
to protect for authorized users only?

 

[Rae]

Just go to "tools" then "protection" then you can chose to protect jus
the sheet or the whole workbook and just follow the instructions

 

[Gord Dibben]

hal

Note: there are 3 types of Protection which can all be passworded.

1. WorkSheet protection from Tools>Protection
2. WorkBook protection from Tools>Protection
3. File protection from File>Save As>Tools>General Options(XL2002)

And a fourth one if you count Protection on a VBA Project

Which are you referring to?

Gord Dibben Excel MVP

 

[hal9000]

it is not working. the xl file opens any time without
asking to type in passwords.
i'd like to have it always asked for to type in pass
whenever you double clicked or tried to open the file.

 

[Rae]

Hi,
ok i get it now. That function is just to protect the data in th
worksheet. To ensure that user can only open the workbook with
password. Go to "tools"--->"options"-->"security" then type in you
desired password in the white box beside this statement, "fil
encryption for this workbook password to open:". Then just click o
and exit and it should prompt you for password the nest you attempt t
open the workbook. Try if it works.

Regards,
Ra

 

[hal9000]

yes, it worked.
Let me add. You should File -> Preserve by name -> Tools -

General -> type in pass for read and/or write.

i appreciate for your quick reply.