+ Reply to Thread
Results 1 to 2 of 2

Name Manager & .xlam files

  1. #1
    Registered User
    Join Date
    04-16-2020
    Location
    Alberta, Canada
    MS-Off Ver
    365
    Posts
    90

    Name Manager & .xlam files

    Can I run a drop down box off a named range where the named range is in a .xlam file ?

    this doesn't seem to work, yet when I had it as a .xlsm file and referenced the library.xlsm in the name manager it did work.

    My NameManager has: Materials =
    HTML Code: 
    ='[Library.xlam]TableA1'!$AT$4:$AT$1139
    and my combo box ListFillRange is Materials

  2. #2
    Registered User
    Join Date
    04-16-2020
    Location
    Alberta, Canada
    MS-Off Ver
    365
    Posts
    90

    Re: Name Manager & .xlam files

    I swear it's Monday....

    I had to close and reopen after I updated the links. Doesn't make much sense to me, but whatever.

+ 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. XLA to XLAM
    By steven_b46 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-28-2017, 10:33 AM
  2. sales manager & purchase manager sheets command button error
    By rana19 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-24-2016, 07:26 AM
  3. [SOLVED] Open and View xlam Add-in files
    By ptmuldoon in forum Excel General
    Replies: 0
    Last Post: 06-27-2015, 08:49 AM
  4. [SOLVED] Using Modules from xlam files
    By JimDandy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-05-2012, 01:01 PM
  5. Evaluate defined names in .xlam files
    By nymm in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-12-2012, 03:50 PM
  6. Inaccessible XLAM add-in
    By PNCD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2009, 01:32 PM
  7. Replies: 3
    Last Post: 04-03-2008, 03:16 PM

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