Hi all,
I'm new to the macro world and need a little help.
I have a macro that is based on the sheet name and retreives data from different sources depending on that name, the macro is called Get_Data.
I have about 10 sheets at the moment that use the same macro (Get_Data is a Template)
what i would like to do is have all the Get_Data macros run when the workbook opens.
Is there a way to have this happen without naming the macros ie: Get_Data1, get_Data2...etc and run from the workbook when its opened ?
Much Appreciated
Static
I'm new to the macro world and need a little help.
I have a macro that is based on the sheet name and retreives data from different sources depending on that name, the macro is called Get_Data.
I have about 10 sheets at the moment that use the same macro (Get_Data is a Template)
what i would like to do is have all the Get_Data macros run when the workbook opens.
Is there a way to have this happen without naming the macros ie: Get_Data1, get_Data2...etc and run from the workbook when its opened ?
Much Appreciated
Static