Placing a code before Save & Save As

Hi,

I am using Excel 2002 and I want to place a code before my user actually
Save the worksheet or use the Save As using the standard menu and tool bar.
How do I place a code there? The save and save as are in the MS Excel
menu/tool bar. I just want to place a code to do a simple copy and paste.
I don't know how to access so I can place me code. Any tips will be
appreciated. Thank you

you have to use an event code
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)

in the vbeditor open vbproject (control+R)
doube click <thisworkbook> under your file
under the new window on the left hand side choose <workbook>
on the riht hand side choose <before_save>
place the code here
save the file

whenever you save the file the code will fire.


--
remove $$$ from email addresss to send email
======================

"Alex Martinez" <[email protected]> wrote in message
news:#BWGy#[email protected]...
>
> Hi,
>
> I am using Excel 2002 and I want to place a code before my user actually
> Save the worksheet or use the Save As using the standard menu and tool
bar.
> How do I place a code there? The save and save as are in the MS Excel
> menu/tool bar. I just want to place a code to do a simple copy and paste.
> I don't know how to access so I can place me code. Any tips will be
> appreciated. Thank you
>
>
>