#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 921
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
saving workbook Leemac Excel Worksheet Functions 2 February 12th 06 12:28 PM
In Excel saving just a tab of a workbook PC Metal Fabrications Excel Discussion (Misc queries) 1 November 23rd 05 07:50 PM
Saving into 1 workbook as a different worksheet dataman777 Excel Worksheet Functions 0 August 30th 05 11:37 PM
Saving workbook from VB Old Car Excel Discussion (Misc queries) 4 April 30th 05 07:24 AM
Saving a Workbook Dennis Excel Worksheet Functions 1 February 22nd 05 01:03 PM


All times are GMT +1. The time now is 04:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"