How to make the file auto save when print is clicked?

Hi all.
I currently have these macros in my workbook and needs to have the feature of auto save when print. May I know how yo do it? Thanks

Please Login or Register  to view this content.

Which part of e code shld I put it in? Cos I tried earlier can't seem to find the correct place to put

Anyone???????

Here's how I made it work (I'm by no means one of the Guru's so if someone else has a better way of making this work please post)

Your Updated Code

Please Login or Register  to view this content.

Hope this helps
Bramz

Appreciate all... but what if i wan to save it as pdf format?

Hmmm...... Try this (Still saves the file)

Updated Code

Please Login or Register  to view this content.