LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Relative reference for named tabs? Dave in Fair Oaks Excel Worksheet Functions 6 June 19th 07 06:21 PM
reference tabs in a summary sheet as column headers JDR Excel Discussion (Misc queries) 6 March 7th 07 06:04 PM
reference multiple tabs Shitel Excel Worksheet Functions 0 April 11th 06 07:39 PM
search all tabs for tab name specified & lookup reference? BMW Excel Worksheet Functions 5 November 4th 05 04:16 PM
how do i simulate a king queen or jack playing card in excel assum I'm an excel nut... Excel Discussion (Misc queries) 2 February 12th 05 04:55 PM


All times are GMT +1. The time now is 09:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"