Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 921
Default Disable save

Hi,

I have a worksheet that people are using about 3 times a week. The
worksheet has a macro and it creates other csv files and edits some other
worksheets.

Here is the issue - I want to prevent people from making changes to the
worksheet - because if their changes get saved we would have to go back and
figure out how to fix it.

One solution is to just save a backup and replace the worksheet every week
with the backup.

We cant protect the sheet (at least I think that wont work) because to use
it you have to make changes to the cells in the worksheet.

I though we could turn the "save" feature off so that no one can overwrite
the worksheet by saving changes that mess things up?

Any thoughts would be really helpful!

Thanks for you help on this.
 
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
Disable save Firkins Excel Discussion (Misc queries) 5 December 10th 07 09:25 PM
Disable save nobbyknownowt Setting up and Configuration of Excel 1 February 14th 07 08:18 PM
Disable save nobbyknownowt[_2_] Setting up and Configuration of Excel 0 February 13th 07 03:53 PM
Disable save Function JB Excel Discussion (Misc queries) 1 May 25th 05 09:58 PM
Disable "Save As" Option Andy T Excel Discussion (Misc queries) 1 December 10th 04 10:23 AM


All times are GMT +1. The time now is 02:16 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"