Linking an Excel Workbook Tab name to a cell


Posted by Pat on October 05, 2001 11:41 AM

Does anyone know if it is possible to link a workbook tab
name to a cell on a different sheet in Excel?



Posted by faster on October 05, 2001 12:28 PM

You can create a function and use the function wizard
UserDefined functions

put this function in a module in your workbook:

Function TabName()
TabName = ActiveSheet.Name
End Function

in anycell you can use it:
=tabname()