As I mentioned, I added a variable to allow you to do that through code.

In a standard code module, declare the variable at the start

Public fSave As Boolean

Then add a simple save macro

Sub Private SaveMyWB()

fSave = True
ThisWorkbOkk.SaveAs "myFilename.xls" '<==== Change to suit
fSave = False

End Sub

I made it private so that it doesn't show in the list of macros from Excel.
Run it from the VBIDE by setting the cursor within the macro and the F5, or
call it in the immediate window.
--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Petitboeuf" <Petitboeuf.2aispn_1152183302.3181@excelforum-nospam.com> wrote
in message news:Petitboeuf.2aispn_1152183302.3181@excelforum-nospam.com...
>
> Bob
>
> Thank you very much! It does work!!
>
> Well... so much so that... how do i save my workbook with the module in
> AFTER pasting it?!
>
>
> --
> Petitboeuf
> ------------------------------------------------------------------------
> Petitboeuf's Profile:
http://www.excelforum.com/member.php...o&userid=10602
> View this thread: http://www.excelforum.com/showthread...hreadid=558792
>