View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default how to intrupt Save and Save as?

You could add some Workbook_BeforeSave code to the workbook. I can't seem
to find a good reference now, but you should be able to find something by
Googling on it. Make sure you put this in the ThisWorkbook module.
--
HTH,
Barb Reinhardt



"Edward" wrote:

Hi everybody,
How can we intrupt Save and Save as in Excel ? I want to write my own code
instead of svaing a document when user clciks on save
--
Best regards,
Edward