+ Reply to Thread
Results 1 to 2 of 2

Macro not visible in Macro List

  1. 01-06-2021, 09:03 AM #1
    littlebird1
    littlebird1 is offline
    Registered User
    Join Date
    01-06-2021
    Location
    Lodnon
    MS-Off Ver
    365 apps
    Posts
    1

    Macro not visible in Macro List

    Hi All,

    I need some help please. I have a macro that copies specific columns from one workbook into a new workbook, and renames the headers.

    I have saved the vba module into a XLAM file, but its not appearing in the macro list. The sub isn't private and the add-in has been enabled.

    Capture.PNG

    Capture2.PNG
    Reply With QuoteRegister To Reply
  2. 01-06-2021, 10:06 AM #2
    Keebellah
    Keebellah is offline
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Macro not visible in Macro List

    Hi, welcome to the forum, try making is a Public Sub
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. a macro has to make visible a new macro-button
    By Xavier Derille in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-16-2015, 03:15 PM
  2. Macro shows list of worksheets to print but the list goes off desktop and not all visible.
    By tbenitez0801 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-09-2015, 10:43 PM
  3. Excel Macro to remove "0" resuts and then subtotal list with only visible rows
    By crainaud in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-31-2014, 03:44 PM
  4. [SOLVED] Macro to select visible rows containg data in filtered list
    By knevil in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-15-2013, 01:22 PM
  5. Macro created defined list not recognized by macro to populate list
    By CharlieGough in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-28-2013, 02:29 PM
  6. [SOLVED] Looking for help tidying up Macro vba code / visible/non visible buttons
    By darrenkaye in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-03-2012, 11:50 AM
  7. Macro visible in VBA Editor not shown in my Macro list in Excel
    By Eduard in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-09-2008, 02:32 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1