+ Reply to Thread
Results 1 to 5 of 5

Macros Disappear

Hybrid View

  1. #1
    Registered User
    Join Date
    11-07-2023
    Location
    Florida, USA
    MS-Off Ver
    Microsoft 365 and Office
    Posts
    70

    Unhappy Macros Disappear

    Hi- Before I used to click on Developer-->Macros then I will see the list of all my macros in case I need to Edit them or run them. However, as you can see in the attached screenshots none of them are there. Under "Macros in" I select All open workbooks and doesn't work. Then I select "Personal" and nothing. What I need to do so all my macros will show up in this window again?

    Thank you.
    Attached Images Attached Images

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2411
    Posts
    26,739

    Re: Macros Disappear

    First let's make sure you have macros. Hit ALT+F11, and click on the "+" sign to the left of PERSONAL.xlsb in the project navigator to the left. Can you find macros in any of the modules?
    http://www.seiglefamily.com/excel/installvba.html
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    11-07-2023
    Location
    Florida, USA
    MS-Off Ver
    Microsoft 365 and Office
    Posts
    70

    Re: Macros Disappear

    This is what I have.
    Last edited by Ladyj07; 01-23-2024 at 03:35 PM.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2411
    Posts
    26,739

    Re: Macros Disappear

    The only file you have open that is macro-enabled is PERSONAL.XLSB but from this view I can't tell if it actually contains any macros. Under PERSONAL.XLSB, click the + next to Modules. Then double click on any of the modules. Is there VBA code in there?

  5. #5
    Registered User
    Join Date
    11-07-2023
    Location
    Florida, USA
    MS-Off Ver
    Microsoft 365 and Office
    Posts
    70

    Re: Macros Disappear

    Hi- So for some reason I have a bunch of Modules. My macros are in Module 1,5 14,25,29,32 and 33
    Attached Images Attached Images

+ 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. Macros disappear
    By Albert310 in forum Office 365
    Replies: 1
    Last Post: 05-22-2023, 03:52 PM
  2. Excel Macros Disappear
    By zanderaruba in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-07-2021, 07:28 PM
  3. Macros disappear unpredictably
    By backdrop in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-06-2019, 05:44 PM
  4. macros disappear in excel 2010
    By steve_w in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-08-2018, 02:21 AM
  5. Macros that appear and disappear when requirements are met?
    By Earthfury in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 08-08-2012, 01:49 PM
  6. Macros disappear when saving workbook in Windows 7
    By LATrojan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-19-2010, 07:15 PM
  7. [SOLVED] My customized toolbars/macros/Icons disappear. Help!
    By Bill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2006, 11:50 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