David,

Try

ThisWorkbook.VBProject.VBComponents("Sheet1").Name = "NewName"

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"davidm"
wrote in message
...

Can someone kindly help me out with a code to *rename* standard
modules?
I have googled in vain for leads. Even Chip Pearson seemed to
have miss
this one in his comprehensive coverage of codings to manipulate
VBComponents.

[I intend using the first 8 or so characters of ProcedureTitles
to
rename meaningfully and can quite comfortably handle this bit
of
extracting the characters].

TIA

David


--
davidm
------------------------------------------------------------------------
davidm's Profile:
http://www.excelforum.com/member.php...o&userid=20645
View this thread:
http://www.excelforum.com/showthread...hreadid=526630