Run a Macro on Worksheet close?

[sambo24]

How can I adjust this code so it runs everytime the workbook is closed?

Please Login or Register  to view this content.

Thanks in advance

[NeedForExcel]

You can have a Code to run just before the workbook is closed..

Put this on your Workbook Module

Please Login or Register  to view this content.

https://msdn.microsoft.com/en-us/lib.../ff194765.aspx

[sambo24]

Thanks, but I don't think I've done it correctly? Any advice?
Capture.JPG

[NeedForExcel]

Double click on ThisWorkbook and paste the code there..

Be sure that your Macros are enabled..

[sambo24]

Thanks NeedforExcel I've just been looking at your site, looks very intuitive. When I have some spare time I'll be back to purchase a course from you.

I've bookmarked your site and will return soon.

Your guidance is appreciated.

[sambo24]

One last question....

If i want it to run upon workbookopen, what would I change this too?

Please Login or Register  to view this content.

[NeedForExcel]

Here

Please Login or Register  to view this content.

And thank you for your kind words.. I am in the process of updating the Website..