Macro to run when closing workbook

[Oeysbrei]

Hi,

Is it possible to make a macro that runs when closing workbook.
If it is, than I want it to save the workbook in sheet one so when next time I open the workbook it will open sheet one

Regards
Oeysbrei

[xladept]

Hi Oeysbrei,


You can put this event code (or something like it) into your Workbook:

Please Login or Register  to view this content.

XLAdept

[Oeysbrei]

xladept ,

Thank you.
I have tryed some codes before without success, this one worked perfect

Regards
Oeysbrei

[xladept]

Oeysbrei ,

You're welcome - glad to have helped.

XLAdept