Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 77
Default How can we rename modules?

I saw in a vbe of an XL2K sheet some time back that the modules had
different names instead of the usu. module1, module2, etc. I checked around
and looked in properties, etc., but haven't found where to do this. Can
anyone point me in the right direction?

Thanks! :oD


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 227
Default How can we rename modules?

Highlight the Module, then open up the Properties window. The first
entry is the Module name.

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default How can we rename modules?

Hi StargateFanFromWork,

In the VBE, with the module selected, press the F4 key to open the
Properties window; now change the module name

---
Regards,
Norman



"StargateFanFromWork" wrote in message
...
I saw in a vbe of an XL2K sheet some time back that the modules had
different names instead of the usu. module1, module2, etc. I checked
around
and looked in properties, etc., but haven't found where to do this. Can
anyone point me in the right direction?

Thanks! :oD




  #4   Report Post  
Posted to microsoft.public.excel.programming
MVM MVM is offline
external usenet poster
 
Posts: 53
Default How can we rename modules?

In the properties window you can change the name. For properties window
view-properties window. or F4

"StargateFanFromWork" wrote:

I saw in a vbe of an XL2K sheet some time back that the modules had
different names instead of the usu. module1, module2, etc. I checked around
and looked in properties, etc., but haven't found where to do this. Can
anyone point me in the right direction?

Thanks! :oD



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 77
Default How can we rename modules?

"MVM" wrote in message
...
In the properties window you can change the name. For properties window
view-properties window. or F4

"StargateFanFromWork" wrote:

I saw in a vbe of an XL2K sheet some time back that the modules had
different names instead of the usu. module1, module2, etc. I checked

around
and looked in properties, etc., but haven't found where to do this. Can
anyone point me in the right direction?

Thanks! :oD


Thank you to everyone who responded! That was soooo easy, as are most
things once you know how <g. Renamed all my modules to something helpful
for each group of scripts.

Cheers! :oD


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i rename a sheet if the rename tab is inactive? Nelson Excel Worksheet Functions 1 March 3rd 10 10:28 AM
Public, Private, Event modules, Forms modules,,, Jim May Excel Programming 11 October 31st 05 03:12 AM
Basic question - modules and class modules - what's the difference? Mark Stephens[_3_] Excel Programming 9 May 8th 05 11:48 AM
Rename Modules Ian Excel Programming 6 March 29th 05 02:29 PM
When to code in sheet or userform modules and when to use modules Tony James Excel Programming 1 December 16th 04 10:02 PM


All times are GMT +1. The time now is 08:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"