How can I rename a module in VBA?

I cant work out how to rename on of my sub modules?

Does anyone know whether this is possible?

thanks

In the VBA editor, select your module in the Project Explorer
(CTLR+R to view), press F4 to display the properties window and
change the name there.


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

"CarolineHedges"
<CarolineHedges.29ur7g_1151061617.0202@excelforum-nospam.com>
wrote in message
news:CarolineHedges.29ur7g_1151061617.0202@excelforum-nospam.com...
>
> I cant work out how to rename on of my sub modules?
>
> Does anyone know whether this is possible?
>
> thanks
>
>
> --
> CarolineHedges
> ------------------------------------------------------------------------
> CarolineHedges's Profile:
> http://www.excelforum.com/member.php...o&userid=35705
> View this thread:
> http://www.excelforum.com/showthread...hreadid=554928
>

Hi Caroline

Are you able to rename the others ? What is different ?

Best wishes Harald

"CarolineHedges"
<CarolineHedges.29ur7g_1151061617.0202@excelforum-nospam.com> skrev i
melding news:CarolineHedges.29ur7g_1151061617.0202@excelforum-nospam.com...
>
> I cant work out how to rename on of my sub modules?
>
> Does anyone know whether this is possible?
>
> thanks
>
>
> --
> CarolineHedges
> ------------------------------------------------------------------------
> CarolineHedges's Profile:
http://www.excelforum.com/member.php...o&userid=35705
> View this thread: http://www.excelforum.com/showthread...hreadid=554928
>

Try:

Sub Whats_In_A_Name()
ThisWorkbook.VBProject.VBComponents("Module1").Name = "Caroline"
End Sub
--
Gary's Student


"CarolineHedges" wrote:

>
> I cant work out how to rename on of my sub modules?
>
> Does anyone know whether this is possible?
>
> thanks
>
>
> --
> CarolineHedges
> ------------------------------------------------------------------------
> CarolineHedges's Profile: http://www.excelforum.com/member.php...o&userid=35705
> View this thread: http://www.excelforum.com/showthread...hreadid=554928
>
>

Thanks, it worked perfectly.