Excel and macro help needed

[chili]

ok i can use excel to a certain degree but i am now at a point where i am stuck. i have a personal expenditure file i use almost daily and i have my main file plus 2 backups of the file. after editing the file i save it, so to keep the file current i have to save it another 2 times to the backup locations.

i looked round the net and found a macro that works for me however when i close the workbook and reopen it my macro is no longer listed under the developer/marco tab.

where am i going wrong, please try to keep any replies simple

thanks

the macro in question when i run it saves to all 3 locations with 1 click, thats all i want to do

 

[meandu229]

Not brilliant at macros but this doesn't sound like the best method of doing this what if you save a mistake by accident then you have 3 copies of a broken file. Look into a good backup solution with file historys. If not then something like this from MS http://www.microsoft.com/en-us/download/details.aspx?id=15155 which would keep your main folder and 2 backup solders up to date.

 

[chili]

cheers for the reply, it needs to run with windows 10 and sync to onedrive aswell, however i have sussed out my problem i needed to save my file with an .xlsm extension