running multiple macros

Hi

I have a master template of a spreadsheet, within here there are tabs monday to sunday and each has their own macro on it. i created a macro to run these macros one after another but the problem arises when i put some data into the spreadsheet, save it with another name and try to run the new macro. as the macro to run macros name is the name of the template then it will not run. is there a way around this?

and how do i do this?

I'm fairly new to macro's and visual basic so i'm not too sure what you mean to be honest. you said in your first reply about the tab names being hard coded. its not the tab names that are the problem, its the name of the document im working on

This is the macro which i am running and it is saved on a master copy:-


Sub mondaytofriday()
'
' mondaytofriday Macro
'

'
Application.Run _
"'Timesheet with macros master - USE THIS ONE.xlsm'!MONDAY.HideXRows"
Sheets("TUESDAY").Select
Application.Run _
"'Timesheet with macros master - USE THIS ONE.xlsm'!TUESDAY.HideXRows"
Sheets("WEDNESDAY").Select
Application.Run _
"'Timesheet with macros master - USE THIS ONE.xlsm'!WEDNESDAY.HideXRows"
Sheets("THURSDAY").Select
Application.Run _
"'Timesheet with macros master - USE THIS ONE.xlsm'!THURSDAY.HideXRows"
Sheets("FRIDAY").Select
Application.Run _
"'Timesheet with macros master - USE THIS ONE.xlsm'!FRIDAY.HideXRows"


End Sub


As you can see the document is called "Timesheet with macros master - USE THIS ONE.xlsm" When i input data into this document i resave it as something like "10 WK COMM 2nd JULY.xlsm" thus causing a problem with the macro as it doesn't know the file name has been changed

Hope this helps

the spreadsheet is too big to post and i can't remove any tabs as that will mess up the macro.

can you help me or not?

Yeah i found this workaround but each week i will have to go into multiple macros in multiple workbooks, i just wondered if there was a way where instead of the filename being there is was something like ThisWorkbook. thanks for your reply