MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?