Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to prevent any one from opening my workbook
I created a personal data workbook stored in my company network. I do not
want any one in the office to be able to open it and read it. The "Protect" feature under the Tools does NOT prevent someone from opening and reading the data (unless I am doing something wrong!). |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to prevent any one from opening my workbook
If they are smarter than the "average aggie" they will be able to open it,
no matter what you do. -- Don Guillett SalesAid Software "MMCM" wrote in message ... I created a personal data workbook stored in my company network. I do not want any one in the office to be able to open it and read it. The "Protect" feature under the Tools does NOT prevent someone from opening and reading the data (unless I am doing something wrong!). |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to prevent any one from opening my workbook
That's not really what Protect does. It stops people from changing any
locked cells or restructuring the workbook depending on what things you protect. As Don says, even if you do this, it is very easy to break If you want people not to be able to open the workbook, you need to apply a password when you save the workbook. If you have the workbook open, choose Save As rather than just Save. Select Options (maybe Tools | General Options) and put one or more passwords into the Save option box Regards Trevor "MMCM" wrote in message ... I created a personal data workbook stored in my company network. I do not want any one in the office to be able to open it and read it. The "Protect" feature under the Tools does NOT prevent someone from opening and reading the data (unless I am doing something wrong!). |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to prevent any one from opening my workbook
I understand that I cannot get protection from hackers and crackers. But I
want to protect it from regular office staff - if they come across this file, they cannot open it. "Don Guillett" wrote: If they are smarter than the "average aggie" they will be able to open it, no matter what you do. -- Don Guillett SalesAid Software "MMCM" wrote in message ... I created a personal data workbook stored in my company network. I do not want any one in the office to be able to open it and read it. The "Protect" feature under the Tools does NOT prevent someone from opening and reading the data (unless I am doing something wrong!). |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to prevent any one from opening my workbook
Thanks, Trevor. It did the trick.
"Trevor Shuttleworth" wrote: That's not really what Protect does. It stops people from changing any locked cells or restructuring the workbook depending on what things you protect. As Don says, even if you do this, it is very easy to break If you want people not to be able to open the workbook, you need to apply a password when you save the workbook. If you have the workbook open, choose Save As rather than just Save. Select Options (maybe Tools | General Options) and put one or more passwords into the Save option box Regards Trevor "MMCM" wrote in message ... I created a personal data workbook stored in my company network. I do not want any one in the office to be able to open it and read it. The "Protect" feature under the Tools does NOT prevent someone from opening and reading the data (unless I am doing something wrong!). |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to prevent any one from opening my workbook
You're welcome. Thanks for the feedback.
Make sure you make the password complex but memorable ... otherwise people with password crackers will still be able to look at it, if they are really interested ;-) For example: "Pa$$w0rD" would take longer to crack than the more simple "password" Regards "MMCM" wrote in message ... Thanks, Trevor. It did the trick. "Trevor Shuttleworth" wrote: That's not really what Protect does. It stops people from changing any locked cells or restructuring the workbook depending on what things you protect. As Don says, even if you do this, it is very easy to break If you want people not to be able to open the workbook, you need to apply a password when you save the workbook. If you have the workbook open, choose Save As rather than just Save. Select Options (maybe Tools | General Options) and put one or more passwords into the Save option box Regards Trevor "MMCM" wrote in message ... I created a personal data workbook stored in my company network. I do not want any one in the office to be able to open it and read it. The "Protect" feature under the Tools does NOT prevent someone from opening and reading the data (unless I am doing something wrong!). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening Workbook resets calculation to automatic from manual etc | Excel Discussion (Misc queries) | |||
How can I prevent someone from deleting a shared workbook? | Excel Worksheet Functions | |||
How do I prevent someone from deleting a workbook? | Excel Discussion (Misc queries) | |||
Opening workbook in user-defined folder | Excel Worksheet Functions | |||
Why is workbook so slow opening? | Excel Discussion (Misc queries) |