Hi All,
I'm a long time reader of the forum and now my first post. I generally find the solution to my macro requirements by searching the internet, this one has me looking for your help.

I have a workbook with several sheets that I use on a daily basis, one sheet for each day of the week Monday To Sunday. Each sheet has several Macros . Sunday the workbook is saved, copied and the copy is renamed.
The problem I have is, after the name change I then have to reassign macros to the buttons which really defeats the porpoise of having the buttons. The buttons where created using forms control and are strategically scattered throughout the sheets. The workbook name is "Daily Diary week Ending 15-05-16" . The workbook name change is the date
I'm not very good at creating my own macros however I'm getting ok at changing others to suit my individual requirements. I considered recording a macro but it would be quite a long macro.

Any ideas would be greatly appreciated.
Thanks in advance