Password Protection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Floridagal - 24 Jun 2005 19:45 GMT

How do I prevent a workbook from being opened until a password is entered. I
have tried the Tools>Protection>Protect Sheet>Protect Workbook and Protect
and Share Workbook. But each time I save and close the workbook, I can open
it without entering a password.

TIA!

Reply to this Message

George Gee - 24 Jun 2005 19:56 GMT

Hi

File > Save as ,
in the 'Save as' dialogue box, click on 'Tools'
Click on 'General Options', and enter a password.

Hope this is what you are looking for.

George Gee

*Floridagal* has posted this message:

> How do I prevent a workbook from being opened until a password is
> entered. I have tried the Tools>Protection>Protect Sheet>Protect
> Workbook and Protect and Share Workbook. But each time I save and
> close the workbook, I can open it without entering a password.
>
> TIA!

Reply to this Message

Floridagal - 24 Jun 2005 20:13 GMT

Thanks George, that was exactly what I was looking for.

> Hi
>
[quoted text clipped - 14 lines]
> >
> > TIA!

Reply to this Message

George Gee - 24 Jun 2005 20:25 GMT

Hi Floridagal

Happy to help, thanks for the feedback!

George Gee

*Floridagal* has posted this message:

> Thanks George, that was exactly what I was looking for.
>
[quoted text clipped - 16 lines]
>>>
>>> TIA!

Reply to this Message

JE McGimpsey - 24 Jun 2005 20:29 GMT

Just be aware that it's pretty easy to crack:

http://www.mcgimpsey.com/excel/fileandvbapwords.html

> Thanks George, that was exactly what I was looking for.

Reply to this Message

Bill Ridgeway - 24 Jun 2005 22:24 GMT

Beware! Passwords can be cracked VERY easily so should not be relied upon
as a security feature.

Regards.

Bill Ridgeway
Computer Solutions

> How do I prevent a workbook from being opened until a password is entered.
> I
[quoted text clipped - 4 lines]
>
> TIA!

Reply to this Message