save a worksheet to 3 different folders

[nnguys]

I wondered if here was a way to get a macro that saves a worksheet to 3 locations automatically. Currently I do this manually but as there are many users of the worksheet I would like tis tio happen everytime the sheet is shut.

Any help greatly appreciated

[TMS]

To save to another folder you'd have to use Save As, so there's no reason why you can't have a macro that does Save As three times.

Just record a macro while you save the file the first time then modify it as required.

Regards, TMS