change spreadsheet name change
Hi,
I would like to change the spreadsheet name to say whatever I type in cell A1. Please advise thanks TJ |
change spreadsheet name change
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 |
change spreadsheet name change
Right click on sheet tab.
Choose "View code". Paste this in: Private Sub Worksheet_Change(ByVal Target As Range) If Target = Range("A1") Then ActiveSheet.Name = Range("A1").Value End If End Sub 'Close VBA editor. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "TJ" wrote: Hi, I would like to change the spreadsheet name to say whatever I type in cell A1. Please advise thanks TJ |
change spreadsheet name change
Right click sheet tabview code copy/paste this Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address < "$A$1" Then Exit Sub ActiveSheet.Name = Target End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "TJ" wrote in message ... Hi, I would like to change the spreadsheet name to say whatever I type in cell A1. Please advise thanks TJ |
All times are GMT +1. The time now is 02:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com