If you are looking to achieve it using code; try this...

A1 = TestSheet

Launch VBE using Alt+F11. Ctrl+G will launch immediate window. Paste the
below code and enter..

Activesheet.name = Range("A1")

If this post helps click Yes
---------------
Jacob Skaria


"TJ" wrote:

Hi,

I would like to change the spreadsheet name to say whatever I type in cell A1.

Please advise

thanks
TJ