ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Restricting access to workbook (https://www.excelbanter.com/excel-programming/285668-restricting-access-workbook.html)

jeff

Restricting access to workbook
 
How can I prevent others, but not all, from accessing a
workbook? I don't want certain people to see a given
workbook even in read-only fashion.

Andy

Restricting access to workbook
 
The easiest option is to save the file with something in the 'password
to open' field. That way the only people who can open it are those who
you give the password to.

This is not 100% effective as there are password crackers available, but
will keep out 'normal' users.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


All times are GMT +1. The time now is 02:36 AM.

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