Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoUpdate
You can do it with a worksheet change function. Put the code into the VBA
worksheet you want it to run on (not a module VBA module). A worksheet change only works on one worksheet. You must copy it to each worksheet where you want it to run. Sub worksheet_change(ByVal target As Range) If target.Address = "$M$2" Then ActiveSheet.Name = target.Value End If End Sub "Danny" wrote: Hi There, Who can help me with the following, I have below formula to let the Sheet name be updated after filling in a Cell (reference), this is working when i run this macro manually. Sub Rename_Sheet() ActiveSheet.Name = ActiveSheet.Range("M2") End Sub I'm now looking for a way to have the name of the sheet be updated automatically the moment i fill in the Cell? Is there anyone who can help me with this? Thanks Danny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel- how to create external link with autoupdate | Excel Discussion (Misc queries) | |||
Can I add an autoupdate file name insert to the document body? | Excel Discussion (Misc queries) | |||
Autofilter Autoupdate | Excel Discussion (Misc queries) | |||
Help with autoupdate.... | Excel Worksheet Functions | |||
Help with autoupdate.... | Excel Worksheet Functions |