Hi,
I want to know if I can run certain macro if the tab name lets say is "data" or "data2()
So if my active sheet I am using the tabs name can be either "data" or "data2" right.
1st macro is if the first tab name is "Data" then it runs this macro
Sub MacroData ()
If the next time I open the sheet and the first tab name is called "Data2" then it would run
Sub MacroData2 ()
So basically I run the macro right it would look at the tab name. Which would be "data" or "data2" then it would choose what macro to run. Is this possible if so I can use some help.
Any help thanks.
I want to know if I can run certain macro if the tab name lets say is "data" or "data2()
So if my active sheet I am using the tabs name can be either "data" or "data2" right.
1st macro is if the first tab name is "Data" then it runs this macro
Sub MacroData ()
If the next time I open the sheet and the first tab name is called "Data2" then it would run
Sub MacroData2 ()
So basically I run the macro right it would look at the tab name. Which would be "data" or "data2" then it would choose what macro to run. Is this possible if so I can use some help.
Any help thanks.