Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
How can I make a workbook so you need a password to open it period. In other words, I don't want anyone to open it to view the contents in in read only unless they have the password. Thanks!! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Open Help, look up "Open with password"
Stockwell43 wrote: Hello, How can I make a workbook so you need a password to open it period. In other words, I don't want anyone to open it to view the contents in in read only unless they have the password. Thanks!! |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In article , Bob I wrote:
Open Help, look up "Open with password" Stockwell43 wrote: Hello, How can I make a workbook so you need a password to open it period. In other words, I don't want anyone to open it to view the contents in in read only unless they have the password. Note, however, that ther are many password crackers/removers out there. XL passwords will not stop someone that really wants to see the spreadsheet. If there's stuff you don't want seen, don't include it. :) |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Do a FILE/SAVE, or if the file has been previously saved FILE/SAVE AS and at
the top of the file list on the right is a TOOLS drop down list. Click the TOOLS drop down button and select GENERAL OPTIONS. You can set a password to open the file, and if you want to limit who can modify it another password to make changes to the file. -- Kevin Backmann "Stockwell43" wrote: Hello, How can I make a workbook so you need a password to open it period. In other words, I don't want anyone to open it to view the contents in in read only unless they have the password. Thanks!! |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Excellent, thanks Kevin!!
"Kevin B" wrote: Do a FILE/SAVE, or if the file has been previously saved FILE/SAVE AS and at the top of the file list on the right is a TOOLS drop down list. Click the TOOLS drop down button and select GENERAL OPTIONS. You can set a password to open the file, and if you want to limit who can modify it another password to make changes to the file. -- Kevin Backmann "Stockwell43" wrote: Hello, How can I make a workbook so you need a password to open it period. In other words, I don't want anyone to open it to view the contents in in read only unless they have the password. Thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
PAssword protected file will not open | Excel Discussion (Misc queries) | |||
Excel macro to open a password protected workbook | Excel Discussion (Misc queries) | |||
How to delete a password in a protected file that you can't open? | Excel Discussion (Misc queries) | |||
Cannot open password-protected Excel File | Excel Discussion (Misc queries) | |||
Multiple workbook user's with Master workbook - all password protected | Excel Discussion (Misc queries) |