+ Reply to Thread
Results 1 to 3 of 3

How to store name in macro workbook?

  1. #1
    Forum Contributor
    Join Date
    03-04-2015
    Location
    Jakarta
    MS-Off Ver
    15
    Posts
    154

    Question How to store name in macro workbook?

    PERSONAL.XLSB range A1:A3 contains = Apple, Mango, Banana > define name = fruits

    How to make the name can be used on every active workbook?

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: How to store name in macro workbook?

    1) Create the named range in the PERSONAL.XLSB
    2) In your external workbook, create a named range that refers to the PERSONAL named range:

    Name: Fruits
    RefersTo: =Personal.xlsb!Fruits


    So, it's active all the time, but to actually use it in any one workbook, you have to create the dynamic link. But once done, if you edit the source list in the PERSONAL file, that change flows to all the other workbooks.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Forum Contributor
    Join Date
    03-04-2015
    Location
    Jakarta
    MS-Off Ver
    15
    Posts
    154

    Re: How to store name in macro workbook?

    JBeaucaire,

    thanks so much
    Last edited by putritersenyum; 03-21-2016 at 08:24 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Open different workbook and store data to variables
    By Cerkit in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 04-15-2013, 09:40 AM
  2. Input data in one sheet and store data in another workbook (Macro)
    By Sabzero786 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-07-2012, 06:10 AM
  3. VBA button to store data from 1 workbook and paste it in another UN-opened workbook
    By mountaineerhughes in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 07-26-2012, 11:39 AM
  4. Perform macro "on open" specific file- store macro in Personal Macro Workbook?
    By thompssc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2012, 12:38 PM
  5. Macro to Split Workbook and Store New Workbooks in New Folders
    By TenaciousDave in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-09-2010, 12:33 PM
  6. STore the data in another workbook without opening it
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-24-2010, 07:12 AM
  7. store & compress old workbook versions
    By fern in forum Excel General
    Replies: 11
    Last Post: 03-23-2007, 10:56 PM
  8. [SOLVED] Store Information but not in a Workbook
    By Andibevan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2005, 10:06 AM

Tags for this Thread

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