I have a workbook with 3 tabs which I need to rename. However, when the workbook is opened if someone has renamed them, I need to rename them when the workbook is opened. can this be done.
So, the three tabs are called i.e. yesterday, today, tomorrow. but when my macro opens the file the tabs have been re-named monday tuesday wednesday [but they could be called anything]
the macro now needs to re-name them yesterday, today, tomorrow and clear the data from all three tabs.
Is this doable with VBA and if so can someone provide this code please.