+ Reply to Thread
Results 1 to 11 of 11

Macros disappear unpredictably

  1. #1
    Registered User
    Join Date
    03-05-2019
    Location
    New York, USA
    MS-Off Ver
    2003
    Posts
    3

    Macros disappear unpredictably

    I got a new hard drive and completely reinstalled Windows and Office 2003 and ever since then macros disappear randomly from workbooks. Sometimes they're gone forever and sometimes they come back after you open other workbooks. Before that I'd never seen this happen in 15 years.

    Online someone said to go to Window > Unhide > choose personal.xls which helped for a few days and now the macros all vanished again. Anyway that meant personal.xls had to always stay open which was irritating and it never used to be like that.

    PS in case you're thinking of telling me to use a newer version: don't waste your time. Hundreds of people have told me for 10+ years to upgrade and they all failed and you will too. This is non-negotiable. I repeat, you're wasting your time. 2003 is completely perfect for my needs.

  2. #2
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,244

    Re: Macros disappear unpredictably

    Completely perfect, apart from not working as you want it to, and no longer being being supported. Winning.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,231

    Re: Macros disappear unpredictably

    Hi backdrop and welcome to the forum,

    Just a guess, but old Excel used".xls" files and then along came ".xlsx" for the extension. Perhaps you installed a version of Excel that didn't recognize the newer .xlsx type of file? Check what program is supposed to run when you double click on a .xlsx. Read:

    https://www.computerhope.com/issues/ch000572.htm

    BTW - what version of windows are you using as this might explain the behavior also.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Registered User
    Join Date
    03-05-2019
    Location
    New York, USA
    MS-Off Ver
    2003
    Posts
    3

    Re: Macros disappear unpredictably

    Quote Originally Posted by Olly View Post
    Completely perfect, apart from not working as you want it to, and no longer being being supported. Winning.
    Maybe try actually reading my post, dingus.

    Before: Win 7, Excel 2003 - worked perfect for 15 years.
    This week: Reinstalled the SAME THINGS ON THE SAME COMPUTER and now its broken.

    Don't let the door hit you on the way out.

  5. #5
    Registered User
    Join Date
    03-05-2019
    Location
    New York, USA
    MS-Off Ver
    2003
    Posts
    3

    Re: Macros disappear unpredictably

    Quote Originally Posted by MarvinP View Post
    Hi backdrop and welcome to the forum,

    Just a guess, but old Excel used".xls" files and then along came ".xlsx" for the extension. Perhaps you installed a version of Excel that didn't recognize the newer .xlsx type of file? Check what program is supposed to run when you double click on a .xlsx.

    BTW - what version of windows are you using as this might explain the behavior also.
    All I did was reinstall the identical things that had been on the computer for 15 years! All my other 50 or 80 programs work exactly as they did before. Win 7. I've been using xlsx and docx files in Office 2003 for years with no problem - I installed special converters.

  6. #6
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,231

    Re: Macros disappear unpredictably

    The whole question is what is different than when it worked correctly before. You said
    I've been using xlsx and docx files in Office 2003 for years with no problem
    but how about now??

    Have you installed the same upgrades and add-ins on the new hard drive that you had on the old one? This might be the problem. The OS keeps track of each install of software and sets the "Associates" file to run that specific program based on the extension of the filename. My question is - can you open .xls files as well as .xlsx files after the reinstall? Do you have/use OneDrive? This might also present a problem with older versions of Windows.

    I'm trying to brainstorm what is causing the new problem. What changed that you haven't discovered yet? Did your "converters" come from Microsoft or another company?

    Marv

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    40,644

    Re: Macros disappear unpredictably

    Quote Originally Posted by backdrop View Post
    Maybe try actually reading my post, dingus.

    ...

    Don't let the door hit you on the way out.
    This sort of response to another member will not be tolerated. You will see that you have received a warning: more behaviour like this will lead to a ban.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  8. #8
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,231

    Re: Macros disappear unpredictably

    Hey backdrop,

    The order in which you install your software can also make a difference. Those extension associates are in the registry. When you upgrade software or do Add-ins they sometimes expect to see the other product has created a registry entry. The add-in will then update this registry entry. If you install stuff in the wrong order the add-in can't find where to update. I'm just trying to brainstorm what is going on. Are you or were you on a network of some kind? If you were the default locations of stuff may have changed. Perhaps you installed an Add-In in a "Download" directory on the old system and now it is in a MyDocument directory? This kind of stuff has also screwed up my upgrades in the past.

  9. #9
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,231

    Re: Macros disappear unpredictably

    Would we expect nothing less from a New York patron.

    My father in law would always start his questions with "I didn't change anything", before we would discover what he had changed. It is all in the learning experience. Some people just believe the squeaky wheel gets the oil or if you complain loud and long you get more help faster. I don't think backdrop knows we work for free and don't know all answers.

    Hey backdrop - we'd love to help with an answer that works but there are so many pieces to check. If you tell us what caused the problem it would be more helpful. I know that you don't know what caused the problem but we don't either.. ALSO - we don't work for Microsoft or Excel. We are just cute loving people who get a kick out of helping others. It makes us feel like we are smart, I guess.

  10. #10
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,231

    Re: Macros disappear unpredictably

    Hey backdrop,

    More directly to the question. Excel in 2003 saved all files as .xls. Those with macros and those without. When the newer versions came along you needed to save them at .xlsm. Read:
    https://superuser.com/questions/7320...ing-excel-file

    Perhaps you are opening some newer files that are .xlsm and trying to save them as .xls and the VBA part is lost. This would happen if you had macros in a new file and saved it as .xlsx - the macros would be lost. I have no idea how you might check this theory but it is closer than an OS or Regedit type answer.

    I'm just trying to brainstorm on what may be the problem.

  11. #11
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,744

    Re: Macros disappear unpredictably

    PS in case you're thinking of telling me to use a newer version: don't waste your time. Hundreds of people have told me for 10+ years to upgrade and they all failed and you will too. This is non-negotiable. I repeat, you're wasting your time. 2003 is completely perfect for my needs.
    Quote Originally Posted by backdrop View Post
    Maybe try actually reading my post, dingus.

    Before: Win 7, Excel 2003 - worked perfect for 15 years.
    This week: Reinstalled the SAME THINGS ON THE SAME COMPUTER and now its broken.

    Don't let the door hit you on the way out.
    be polite - or leave!!
    Last edited by FDibbins; 03-06-2019 at 05:49 PM.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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 and personal workbook disappear in Prosystems Fx engagement
    By foxtrotter in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-25-2018, 11:26 AM
  2. macros disappear in excel 2010
    By steve_w in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-08-2018, 02:21 AM
  3. Replies: 2
    Last Post: 08-06-2013, 01:58 AM
  4. 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
  5. Replies: 2
    Last Post: 03-04-2012, 11:58 AM
  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

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