Beforesave code applied to any file

Hi,

I know how to include a beforesave code for a given file. I also know how to have my general macros always available by having them in a personal.xlsb file.
But I want to have a beforesave macro that would run when I save any file without having to add it to each file individually. Is there a way to do that?

Thanks

Stéphane

Hi there,

Run the following code from the Immediate Window:

Please Login or Register  to view this content.

It will give you a folder path similar to

"C:\Users\UserId\AppData\Roaming\Microsoft\Excel\XLSTART"

Insert the attached file in the folder identified above, and start Excel - this will open a hidden workbook which contains code which will be executed before any workbook is saved.

You can insert your own code in the appropriate location in the Class Module:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards.

Greg M

Thank Greg,

It worked perfectly fine! Now I won't forget to select cell A1 of sheet1 when saving and closing a file as per our business policy.
The request can be closed.

Stéphane

Hi again Stéphane,

Many thanks for your feedback - I'm very pleased that I was able to help.

Bien à vous,

Greg M