Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Force macro on save
I want to create a macro to run when users of a shared woorbook hit save or
save as, as a way of protecting the master data set. My data will contain many columns such as standard cost and selling prices, i only want to allow the save if they have not corrupted formatting or data validation. Is this possible? I've made a start with a MsgBox code but not sure how to proceed... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Force macro on save
Meltad,
There is a Workbook_BeforeSave event, so you can check if everything is OK. If not then set Cancel=True to abort the save NickHK "Meltad" wrote in message ... I want to create a macro to run when users of a shared woorbook hit save or save as, as a way of protecting the master data set. My data will contain many columns such as standard cost and selling prices, i only want to allow the save if they have not corrupted formatting or data validation. Is this possible? I've made a start with a MsgBox code but not sure how to proceed... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Force macro on save
Hi Nick,
Do you have anymore detail on how to use this?.. I'm a beginner! "NickHK" wrote: Meltad, There is a Workbook_BeforeSave event, so you can check if everything is OK. If not then set Cancel=True to abort the save NickHK "Meltad" wrote in message ... I want to create a macro to run when users of a shared woorbook hit save or save as, as a way of protecting the master data set. My data will contain many columns such as standard cost and selling prices, i only want to allow the save if they have not corrupted formatting or data validation. Is this possible? I've made a start with a MsgBox code but not sure how to proceed... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you force excel to save on close | Excel Discussion (Misc queries) | |||
Force Save over existing file | Excel Programming | |||
Force worksheet to NOT save | Excel Programming | |||
Force save as | Excel Discussion (Misc queries) | |||
force upate to datbase using save as | Excel Programming |