+ Reply to Thread
Results 1 to 3 of 3

User Defined Functions in the Personal Macro Workbook

  1. #1
    Nate
    Guest

    User Defined Functions in the Personal Macro Workbook

    When using a UDF stored in the Personal Macro Workbook, is there a way
    to eliminate the need to type the name of the workbook
    (PERSONAL.XLS!...) before the function name? Or, if not, is there a
    way to change the name of the Workbook to something much shorter, like
    one letter?


  2. #2
    Bob Phillips
    Guest

    Re: User Defined Functions in the Personal Macro Workbook

    Just rename it in the XLStart directory.

    --
    HTH

    Bob Phillips

    (remove xxx from email address if mailing direct)

    "Nate" <npursley@gmail.com> wrote in message
    news:1147357780.023555.291360@j73g2000cwa.googlegroups.com...
    > When using a UDF stored in the Personal Macro Workbook, is there a way
    > to eliminate the need to type the name of the workbook
    > (PERSONAL.XLS!...) before the function name? Or, if not, is there a
    > way to change the name of the Workbook to something much shorter, like
    > one letter?
    >




  3. #3
    Peo Sjoblom
    Guest

    Re: User Defined Functions in the Personal Macro Workbook

    Another thing is to put the UDF in a workbook and save it as an add-in
    (*.xla) then select it under tools>add-ins

    --

    Regards,

    Peo Sjoblom

    http://nwexcelsolutions.com


    "Bob Phillips" <bob.NGs@googlemailxxx.com> wrote in message
    news:etxwunQdGHA.1324@TK2MSFTNGP04.phx.gbl...
    > Just rename it in the XLStart directory.
    >
    > --
    > HTH
    >
    > Bob Phillips
    >
    > (remove xxx from email address if mailing direct)
    >
    > "Nate" <npursley@gmail.com> wrote in message
    > news:1147357780.023555.291360@j73g2000cwa.googlegroups.com...
    >> When using a UDF stored in the Personal Macro Workbook, is there a way
    >> to eliminate the need to type the name of the workbook
    >> (PERSONAL.XLS!...) before the function name? Or, if not, is there a
    >> way to change the name of the Workbook to something much shorter, like
    >> one letter?
    >>

    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1