run a macro when clicking on "save as"
 

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

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

run a macro when clicking on "save as"
 

Before_save can be used. In case the file is saveasUi
variable will be true if you are saving it the first time
or you are doing a Save As event.

Regards
Sharad.



-----Original 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


.