View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Need Code to rename standard modules

Even Chip Pearson seemed to have miss
this one in his comprehensive coverage of codings to manipulate
VBComponents.


Actually, the info is hidden on the CodeMods page,
http://www.cpearson.com/excel/codemods.htm . I'll add it to the
VBE page.


--
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