+ Reply to Thread
Results 1 to 9 of 9

Missing Macros

  1. #1
    Registered User
    Join Date
    08-22-2014
    Location
    Monterrey
    MS-Off Ver
    2010
    Posts
    42

    Missing Macros

    I have a large file, with 18 Modules and 17 macros in it. Today, when I opened up the file, the macros were gone, they're missing, and when I go to VBA, it shows nothing, it's grey.

    Screenshot 2022-10-26 102749.jpg

    This is not the first time this happens. Usally, I go to a previous version and bring the file up to date, but I'm tired of having to do the re-work at least once a week. Does anyone have an idea on how to fix this, how to recover the macros, why is this happening?

    On a side note, when ever this happens, a message pops up saying, "CAN'T SAVE There was a problem saving and AutoSave was disabled. Please Dave As or close and reopen the file.". When this shows up, I know I'm in trouble

    Thanks for your help

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: Missing Macros

    Is it still grey after double-clicking on one of the modules?
    Rory

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,434

    Re: Missing Macros

    You should find that double clicking on any module will display the code window. Or press F7. Or choose View and select Code.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Registered User
    Join Date
    08-22-2014
    Location
    Monterrey
    MS-Off Ver
    2010
    Posts
    42

    Re: Missing Macros

    Correct! It's still grey.

  5. #5
    Registered User
    Join Date
    08-22-2014
    Location
    Monterrey
    MS-Off Ver
    2010
    Posts
    42

    Re: Missing Macros

    It doesn't. It's as if the Modules were disabled

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,434

    Re: Missing Macros

    Guessing here. Can you post a copy of the workbook that displays the problem? Remove any sensitive information.


    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

  7. #7
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: Missing Macros

    If you select Window - Cascade from the menu after double-clicking the module, can you then see the code window?

  8. #8
    Registered User
    Join Date
    08-22-2014
    Location
    Monterrey
    MS-Off Ver
    2010
    Posts
    42

    Re: Missing Macros

    I can't! Excel won't allow me to save the file

    Screenshot 2022-10-26 114232.jpg

  9. #9
    Registered User
    Join Date
    08-22-2014
    Location
    Monterrey
    MS-Off Ver
    2010
    Posts
    42

    Re: Missing Macros

    Still, nothing

+ 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. Using an Excel ss w/macros on a Mac laptop, error when opening, missing kernel32
    By thecdnmole in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 04-18-2016, 04:21 AM
  2. Macros/Finding missing and complete addresses
    By tutv088 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2014, 12:27 PM
  3. Macros fail due to missing libraries
    By MJH1974 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-10-2013, 05:03 AM
  4. PERSONAL.xls file has gone missing along with the macros
    By drums4monty in forum Excel General
    Replies: 3
    Last Post: 02-29-2008, 04:33 AM
  5. Macros, Protected Books & Missing Passwords
    By jamesanddavid in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-15-2005, 01:06 PM
  6. Allowing events/macros during formula mode?-something I'm missing
    By shorowit in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-09-2005, 11:06 AM
  7. Upraded from 2002 to 2003 -- Macros missing
    By Lexisch in forum Excel General
    Replies: 4
    Last Post: 01-10-2005, 03:06 PM

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