Hi all,
Sorry about this, but I'm a bit of a newbie to Macros (never even
opened
VB until yesterday...)
I have some code that changes a sheet name to the contents of a
particular cell:
Sub ChangeSheetNames()
ActiveSheet.Name = Range("b7")
End Sub
Now I can create a button that activates the Macro when you press it.
However I want the sheet name to change as soon as the cell contents
are changed, not when you press abutton. How do I do that?
Sorry to be dumb.
Gavin
--
Gavin Ling
------------------------------------------------------------------------
Gavin Ling's Profile:
http://www.excelforum.com/member.php...o&userid=30110
View this thread:
http://www.excelforum.com/showthread...hreadid=498726