ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Passwords on Worksheets (https://www.excelbanter.com/excel-worksheet-functions/101215-passwords-worksheets.html)

sp3cialist

Passwords on Worksheets
 
I need to be able to password protect a worksheet that has been created, that
has validation applied amongst other settings and stop users resaving it as
another file and then altering the layout and structure.

I need them to complete the structured worksheet, not resave it and then
alter it. Is there a way around this? Can you remove the Save As option?

Thank you.


All times are GMT +1. The time now is 10:45 PM.

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