Force macro on save

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
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
 
Hi Nick,

Do you have anymore detail on how to use this?.. I'm a beginner!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lose macros before saving 4
Cannot save macro spreadsheet due to ReadOnly = True 1
Macro to save contents of a named range to a file 7
Auto Save 2
Save workbook button on Userform 2
security, enabling macros to enable a disabling saving function 12
Saving a Word document as PDF from en Excel macro 2
delete macro button once file is saved 4

Back
Top