ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Locked cells (https://www.excelbanter.com/excel-worksheet-functions/6632-locked-cells.html)

Pam Coleman

Locked cells
 
Is is possible to give one person access to locked cells and deny another
user. I know I can stop them from saving any changes, but I'm afraid if they
make changes and print it and then not save, there will be a lot of printed
wrong changes.

Lady Layla

Depending on version of Excel, you can lock the cells and not even allow those
cells to be selected by those without the password

I know this works in Excel 2002 and 2003 and does not in 97.


"Pam Coleman" wrote in message
...
: Is is possible to give one person access to locked cells and deny another
: user. I know I can stop them from saving any changes, but I'm afraid if they
: make changes and print it and then not save, there will be a lot of printed
: wrong changes.




All times are GMT +1. The time now is 05:59 AM.

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