Macro to global
Manage your personal finances in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Macro to global

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I want to move my completed macro to the global file so that I can use the macro from any excel spreadsheet not just one workbook(worksheet) at a time. How do I do this. Thanks in advance.

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Save it to Personal.xls

    If you have never used Personal.xls then follow the following steps to edit it:

    1. Test to see if Personal.xls already exists by going to Windows-Unhide. If this is an option then click unhide and this will unhide personal.xls.
    2. Open up VBA and paste your code into a module in Personal.xls
    3. If Unhide is not an option, then Personal.xls does not exist.
    4. On the Tools menu, point to Macro, and then click Record New Macro.
    5. To save the macro in a hidden workbook that is automatically loaded when you start Excel, choose Personal Macro Workbook.
    6. Go back to step 1.

    _________________
    Hope this helps.
    Kind regards, Al.

    [ This Message was edited by: Al Chara on 2002-04-15 11:44 ]

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