PDA

View Full Version : Solved: Better understand macros



Adonaioc
12-01-2008, 07:56 AM
This may be a novice question but I want to know how to clean up the name of my macros. Whenever I make a macro it gives it a long thisworkbook.yada yada.whatever name but some macros that i have downloaded are just the name of the macro. How is this accomplished?

Attached a screenshot to better explain.

Kenneth Hobs
12-01-2008, 08:22 AM
It is probably from another workbook that you have open. The other part of the name is the sheet name most likely. So, you would need to shorten your filename and/or sheet names as well as the macro names.

Hoopsah
12-01-2008, 08:22 AM
Hi Adonaioc

when you create a macro, you are asked at that point what you want to call it.

If you have already created it you can still amend the name - probably the easiest way to amend the name is to open up Visual Basic and type a new name for the macro.

Paul_Hossler
12-02-2008, 01:26 PM
You might have a worksheet or some other Excel "thing" called 'CreatePartNumber' so the RunMacro puts in the parent names.

Paul