Bypass Beforesave Macro while developing

Mark:

i am fairly new to VBA myself and I am working on a macro do do something very similar, could you post your code, I am hjaving a difficult time getting mine to work.

Brad

CBG05QB, No bother.

As per the suggestion of mohd9876, I simply have a macro as below and do a run macro everytime I wish to save the file. The typical users of the Excel file won't be aware and hence will only successfully save the file when the cells are correctly entered. If you wish to save to a different file, you need to replace .Save with .SaveAs.

-------
Sub SaveCopies()
Application.EnableEvents = False
ActiveWorkbook.Save
Application.EnableEvents = True
End Sub
------

Hope it helps.