Consulting

Results 1 to 4 of 4

Thread: Solved: Better understand macros

  1. #1
    VBAX Regular
    Joined
    Mar 2008
    Posts
    78
    Location

    Solved: Better understand macros

    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.

  2. #2
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,903
    Location
    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.

  3. #3
    VBAX Tutor Hoopsah's Avatar
    Joined
    Nov 2007
    Posts
    299
    Location
    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.
    I am playing all the right notes, but not necessarily in the right order.
    Eric Morecambe

  4. #4
    VBAX Wizard
    Joined
    Apr 2007
    Posts
    7,001
    Location
    You might have a worksheet or some other Excel "thing" called 'CreatePartNumber' so the RunMacro puts in the parent names.

    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •