Solved: Better understand macros

[Adonaioc]

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]

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]

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]

You might have a worksheet or some other Excel "thing" called 'CreatePartNumber' so the RunMacro puts in the parent names.

Paul