Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I name Worksheet Tabs based on some king of reference?
Yes
Basic event code in the worksheet module would be................. Private Sub Worksheet_Calculate() Me.Name = Range("C2").Value End Sub But I would suggest you check out this google search thread for various sets of event code from Dave Peterson that cover several scenarios. http://groups.google.com/group/micro...c8d6cf55155e92 Gord Dibben MS Excel MVP On Tue, 31 Jul 2007 09:56:41 -0700, e12762r wrote: Does anyone know if it's possible to Name an Excel Worksheet Tab based on some kind of reference (cell) or calculation or function? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Relative reference for named tabs? | Excel Worksheet Functions | |||
reference tabs in a summary sheet as column headers | Excel Discussion (Misc queries) | |||
reference multiple tabs | Excel Worksheet Functions | |||
search all tabs for tab name specified & lookup reference? | Excel Worksheet Functions | |||
how do i simulate a king queen or jack playing card in excel assum | Excel Discussion (Misc queries) |