View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Using VBE to change tab name

Hi Joeski,

Try:

'=============
Public Sub Tester004()
Sheets("Sheet1").Name = "MySheet"
End Sub
'<<=============


---
Regards,
Norman



"joeski" wrote in message
...
Hi

How do I change the tab name for a worksheet in VBE?
--
joeski