Basic Beginners Query
Basic Beginners Query
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Basic Beginners Query

  1. #1
    Guest

    Default

     

    After copying a macro and then pasting it into the visual basic editor, how do i then save it so that when i go to macros and attempt to run it it appears.?

    Sorry for being very dense!

  2. #2
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-08 10:14, Anonymous wrote:

    After copying a macro and then pasting it into the visual basic editor, how do i then save it so that when i go to macros and attempt to run it it appears.?

    Sorry for being very dense!
    No need to apologize, we've all been there. After copying your macro you need to select the workbook where you want to keep you macro. In your Project Explorer window (usually the top left window with the title - "Project - VBA Project") highlight the workbook where you want to keep your macro. Then, from the main menu, select Insert|Module. Your window on the right hand side will then have a blank module, and you'll notice that you have a module folder under your file in the Project Explorer window. Paste your macro in the module window and then save your file (File|Save).

    Is this explanation sufficient?

    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  3. #3
    Guest

    Default

    should i then be able to open this thro' tools>macro>macros, because that's what i want to do but still don't seem to be having any luck?!

  4. #4
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-08 10:42, Anonymous wrote:
    should i then be able to open this thro' tools>macro>macros, because that's what i want to do but still don't seem to be having any luck?!
    Yes. If you need any further help just let me know.

    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  5. #5
    Guest

    Default

    Sorry Barrie, still no joy - after selecting the workbook (VBAProject newtest.xls), i then inserted the module and pasted my macro.
    Then saved - file>save newtest.xls, it appeared to save, but i still can't find the macro when i want to select it as discussed above.

  6. #6
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-08 10:58, Anonymous wrote:
    Sorry Barrie, still no joy - after selecting the workbook (VBAProject newtest.xls), i then inserted the module and pasted my macro.
    Then saved - file>save newtest.xls, it appeared to save, but i still can't find the macro when i want to select it as discussed above.
    Can you e-mail your file to me so I can actually see it (taking out any sensitive information)?

    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  7. #7
    Guest

    Default

      
    Barrie

    I've cracked it, I couldn't find it because it was a macro that opened up a message prompt only when the file is opened - sorry mate but thanks for your time.
    I'm having a blonde day!

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com