Thread: run a macro when clicking on "save as"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Andy Wiggins[_2_] Andy Wiggins[_2_] is offline
external usenet poster
  
Posts: 11
Default run a macro when clicking on "save as"
In "Thisworkbook", take a look at the BeforeSave event:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)

End Sub

--

Regards
Andy Wiggins
www.BygSoftware.com
Home of "The Excel Auditor" and "Byg Tools for VBA"



"M K W" wrote in message
...
Hello,
How to run a macro when I click on Save As?
When I click on "save as" I want a macro to run, do something, then the
"save as" will take place and the save as window appears.
thanx in advance




Reply With QuoteReply With Quote