Thread: Automatically name worksheet tab w/cell formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill B[_4_] Bill B[_4_] is offline
external usenet poster
  
Posts: 1
Default Automatically name worksheet tab w/cell formula
I would like to be able to automatically name my worksheet
tabs.

Is there a cell formula or macro that I can use so that:

If: The contents of cell A1 is 'January 1, 2004'
Then: The worksheet tab automatically is changed to
'January 1, 2004'

Also, can anyone recommend books on VB programming
(beginner level) for Excel?

Thanks,

Bill
Reply With QuoteReply With Quote