Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Disable save
hi
try something like this.... Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Cancel = True MsgBox ("saving this file is fobidden!") Workbooks("yourfile.XLS").Close SaveChanges:=False End Sub "Jeff" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Disable save
I would think that you should put the workbook file in a network folder
where users do not have rights to save a file (no 'write rights'). -- Jim "Jeff" wrote in message ... | 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable save | Excel Discussion (Misc queries) | |||
Disable save | Setting up and Configuration of Excel | |||
Disable save | Setting up and Configuration of Excel | |||
Disable save Function | Excel Discussion (Misc queries) | |||
Disable "Save As" Option | Excel Discussion (Misc queries) |