Archive of Mr Excel Message Board

Back to Dates in Excel archive index
Back to archive home

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

Re: Can I put a formula in a tab label?

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

Re: Can I put a formula in a tab label?

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

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.