ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Password protection of files (https://www.excelbanter.com/setting-up-configuration-excel/78867-password-protection-files.html)

Polyprod

Password protection of files
 
Is there a way to password protect Excel files so that they cannot even be
viewed. The standard password protection only seems to protect the file from
being changed. I would like sensitive worksheets i.e. payroll files, from
being viewed at all.

Any help appreciated.

Paul B

Password protection of files
 
Polyprod, you can set a password to open the file, to change the file you
have, file, save as, select tools, general options, save options, enter
password to open confirm password and OK out.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Polyprod" wrote in message
...
Is there a way to password protect Excel files so that they cannot even be
viewed. The standard password protection only seems to protect the file

from
being changed. I would like sensitive worksheets i.e. payroll files, from
being viewed at all.

Any help appreciated.




Polyprod

Password protection of files
 


"Paul B" wrote:

Polyprod, you can set a password to open the file, to change the file you
have, file, save as, select tools, general options, save options, enter
password to open confirm password and OK out.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


Many thanks for your response.
I haven't used Excel in ages and had forgotten how to do it.

Much appreciated Paul

Paul B

Password protection of files
 
Your welcome
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Polyprod" wrote in message
...


"Paul B" wrote:

Polyprod, you can set a password to open the file, to change the file you
have, file, save as, select tools, general options, save options, enter
password to open confirm password and OK out.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


Many thanks for your response.
I haven't used Excel in ages and had forgotten how to do it.

Much appreciated Paul





All times are GMT +1. The time now is 01:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com