Can I put a formula in a tab label?

Posted by GLITZ on December 17, 2000 3:40 PM

Example:
Can i make the name of a tab be the name of the workbook?

so when the workbook is renamed so is the tab.

Thank you

Posted by Celia on December 17, 2000 7:21 PM

Try putting the following procedures in the ThisWorkbook module :-

Private Sub Workbook_Open()
Sheet1.Name = Application.ExecuteExcel4Macro _
("get.document(88)")
End Sub

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
Sheet1.Name = Application.ExecuteExcel4Macro _
("get.document(88)")
End Sub

Celia

Posted by GLITZ on December 18, 2000 5:12 AM

Where do I find "This workbook module"?
Is that a VBA control?