#1   Report Post  
wal50
 
Posts: n/a
Default Renaming Macros

I didn't do a very good naming job for the macros I created. Now I have
more than I can remember what the do. I want to make the names more
descriptive.
How do I do that? The other Q/A I found all referred to changed file names
or some other problem I don't have. I just want to change the names and
leave them in the same file.
Thanks in advance,
wal50

  #2   Report Post  
Nick Hodge
 
Posts: n/a
Default

Wal

Open the file, press Alt+F11 and then double click any modules in the left
window. This will open the code, simply change the name. remember no
spaces, reserved names, and certain characters

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"wal50" wrote in message
...
I didn't do a very good naming job for the macros I created. Now I have
more than I can remember what the do. I want to make the names more
descriptive.
How do I do that? The other Q/A I found all referred to changed file
names
or some other problem I don't have. I just want to change the names and
leave them in the same file.
Thanks in advance,
wal50



  #3   Report Post  
wal50
 
Posts: n/a
Default

Thanks Nick

"wal50" wrote:

I didn't do a very good naming job for the macros I created. Now I have
more than I can remember what the do. I want to make the names more
descriptive.
How do I do that? The other Q/A I found all referred to changed file names
or some other problem I don't have. I just want to change the names and
leave them in the same file.
Thanks in advance,
wal50

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
Enabling macros Peter M Excel Discussion (Misc queries) 3 February 7th 05 10:57 PM
sorting with macros Sorting in macros Excel Discussion (Misc queries) 1 February 1st 05 09:02 AM
Transferring toolbars and macros to other computers Darrell Excel Discussion (Misc queries) 1 January 19th 05 12:21 AM
The available macros list in XL; how to suppress filename from showing KR Excel Discussion (Misc queries) 1 January 10th 05 07:20 PM
Macros disappear after a file is imported Brent E Excel Discussion (Misc queries) 1 December 18th 04 12:25 AM


All times are GMT +1. The time now is 03:50 AM.

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

About Us

"It's about Microsoft Excel"