Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Password Protection
How do I prevent a workbook from being opened until a password is entered. I
have tried the ToolsProtectionProtect SheetProtect Workbook and Protect and Share Workbook. But each time I save and close the workbook, I can open it without entering a password. TIA! |
#2
|
|||
|
|||
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 ToolsProtectionProtect SheetProtect Workbook and Protect and Share Workbook. But each time I save and close the workbook, I can open it without entering a password. TIA! |
#3
|
|||
|
|||
Thanks George, that was exactly what I was looking for.
"George Gee" wrote: 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 ToolsProtectionProtect SheetProtect Workbook and Protect and Share Workbook. But each time I save and close the workbook, I can open it without entering a password. TIA! |
#4
|
|||
|
|||
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. "George Gee" wrote: 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 ToolsProtectionProtect SheetProtect Workbook and Protect and Share Workbook. But each time I save and close the workbook, I can open it without entering a password. TIA! |
#5
|
|||
|
|||
Just be aware that it's pretty easy to crack:
http://www.mcgimpsey.com/excel/fileandvbapwords.html In article , "Floridagal" wrote: Thanks George, that was exactly what I was looking for. |
#6
|
|||
|
|||
Beware! Passwords can be cracked VERY easily so should not be relied upon
as a security feature. Regards. Bill Ridgeway Computer Solutions "Floridagal" wrote in message ... How do I prevent a workbook from being opened until a password is entered. I have tried the ToolsProtectionProtect SheetProtect 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password protection for Excel sheets | Excel Discussion (Misc queries) | |||
Changing password protection on sheets | Excel Discussion (Misc queries) | |||
Password Protection - Excel | Excel Discussion (Misc queries) | |||
How to define separate Password Protection, to say 3 persons, for. | Excel Worksheet Functions | |||
Password protection | Excel Discussion (Misc queries) |