normal save but with modified filename

I'm trying to force a file name when the default save button (or close) is triggered

I have a script that works when called as a macro, but when I drop it into the 'Thisworkbook' object it seems to run twice and then crash excel.

The script is below, but my question is more generic... what do I need to do if I want to force a file name change when generic save functions are called?

Please Login or Register  to view this content.