Naming Worksheet tabs

**Pickygame** · 04-20-2009, 08:09 AM

Is it possible to name a worksheet tab from a cell reference on a worksheet?

**c_m** · 04-20-2009, 08:17 AM

Assuming A1 has the name, try this macro in module:

Sub worksheetrename()

ActiveSheet.Name = Range("A1")

End Sub

**VBA Noob** · 04-20-2009, 08:18 AM

see if link helps

http://www.mcgimpsey.com/excel/event...efromcell.html

VBA Noob

**VBA Noob** · 04-20-2009, 08:19 AM

c_m,

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

VBA Noob

**Pickygame** · 07-06-2009, 08:19 AM

Hi
I set up a module - ActiveSheet.Name = Range("A1") but it relates to a single worksheet. How do i use the same Module for every worksheet without recreating a module for every sheet?

Thanks