Results 1 to 4 of 4

Thread: Macros personal library
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jan 2005
    Posts
    310
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Macros personal library

    I update to Excell 2003 and i need to set up my personal library of macros. can anyone give a hint, How can a create a VBA project that it will stay active all teh time i am using excell

    Thanks

  2. #2
    Board Regular
    Join Date
    Oct 2004
    Location
    Kerala, India
    Posts
    1,926
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,
    When you record macros, store it in personal.xls instead of This Workbook. Then it will be available whenever you use Excel.

  3. #3
    Board Regular
    Join Date
    Jan 2005
    Posts
    310
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanx but how i create the PERSONAL.xls

  4. #4
    MrExcel MVP Richie(UK)'s Avatar
    Join Date
    May 2002
    Location
    UK
    Posts
    3,329
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi D,

    Record a macro and in the 'Store macro in' box select 'Personal Macro Workbook'.

    HTH
    Richie

Some videos you may like

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
  •