Is it possible to name an excel seet dynamically based on workbook?

[TonyU]

[tt]
Can someone help me with code on how to accomplish this ? The name of my workbook is call Monthtly Report (changing monthly to the current month) so, my sheet will read Monthly Report.

[tt]"A Successful man is one who can build
a firm foundation with the bricks
that others throw at him"
[/tt]

​

 

[aMember]

Instead of referencing the sheet by the name, use the index instead and put this code in the workbook open event.

Sheets(1).Name = ThisWorkbook.Name