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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.