Initiate Macro On Save
 

I need to initiate a macro when someone tries to "save" or "save as...
a file. Is that possible

--
JTWoo
-----------------------------------------------------------------------
JTWood's Profile: http://www.excelforum.com/member.php...fo&userid=3419
View this thread: http://www.excelforum.com/showthread.php?threadid=55161

Initiate Macro On Save
 

There is a Before Save Event associted with ThisWorkbook. Right Click the
Excel Icon next to File on the menu bar and select View Code. Then paste the
following...

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
msgbox "you are saving..."
End Sub
--
HTH...

Jim Thomlinson


"JTWood" wrote:


I need to initiate a macro when someone tries to "save" or "save as..."
a file. Is that possible?


--
JTWood
------------------------------------------------------------------------
JTWood's Profile: http://www.excelforum.com/member.php...o&userid=34192
View this thread: http://www.excelforum.com/showthread...hreadid=551610

Initiate Macro On Save
 

Jim Thomlinson Wrote:
There is a Before Save Event associted with ThisWorkbook. Right Clic
the
Excel Icon next to File on the menu bar and select View Code. The
paste the
following...

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel A
Boolean)
msgbox "you are saving..."
End Sub
--
HTH...

Jim Thomlinson


"JTWood" wrote:


I need to initiate a macro when someone tries to "save" or "sav
as..."
a file. Is that possible?


--
JTWood

------------------------------------------------------------------------
JTWood's Profile
http://www.excelforum.com/member.php...o&userid=34192
View this thread
http://www.excelforum.com/showthread...hreadid=551610


Excellent. I will try this out today.

Thanks

--
JTWoo
-----------------------------------------------------------------------
JTWood's Profile: http://www.excelforum.com/member.php...fo&userid=3419
View this thread: http://www.excelforum.com/showthread.php?threadid=55161