ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Saving Workbook (https://www.excelbanter.com/excel-discussion-misc-queries/137280-saving-workbook.html)

Jeff

Saving Workbook
 
Hi,

This question probably has a very simple answer.

Problem = I have a worksheet "Weekly Runs.xls" and I do not want anyone
resaving the worksheet - but I don't want to protect the contents of the
worksheet because I want people to be able to play around with it - I just
don't want people making changes and resaving the worksheet. So is there a
settings you can set so that people can't resave the worksheet as "Weekly
Runs.xls"?

Thanks for your help

Dave Peterson

Saving Workbook
 
You can mark the file as readonly in windows explorer. That makes it slightly
more difficult to destroy your original workbook.

You can file|SaveAs|Tools|General Options
and give it a password to modify (not open).

This can make it slightly more difficult, too.

But if you really want to protect it, talk to your IT staff and ask for a
network share that only you have write access to--but allow others to have read
access.

You may want to allow a trusted coworker to have write access, too (when you're
on vacation???).

Jeff wrote:

Hi,

This question probably has a very simple answer.

Problem = I have a worksheet "Weekly Runs.xls" and I do not want anyone
resaving the worksheet - but I don't want to protect the contents of the
worksheet because I want people to be able to play around with it - I just
don't want people making changes and resaving the worksheet. So is there a
settings you can set so that people can't resave the worksheet as "Weekly
Runs.xls"?

Thanks for your help


--

Dave Peterson


All times are GMT +1. The time now is 02:37 PM.

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