ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Renaming Macros (https://www.excelbanter.com/excel-discussion-misc-queries/15963-renaming-macros.html)

wal50

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


Nick Hodge

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




wal50

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



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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com