Worksheet Tabs
Posted by Stephen on January 16, 2002 7:11 AM
Is there a way to change the name of a worksheet tab based on a result from a formula?
Posted by Jacob on January 16, 2002 7:49 AM
Hi
Lets say the name you want is in A1 then in the code for the worksheet put this
Sub Worksheet_Activate
activeworkbook.name = range("A1").value
end sub
HTH
Jacob
