+ Reply to Thread
Results 1 to 5 of 5

macros disappear in excel 2010

  1. #1
    Registered User
    Join Date
    08-22-2012
    Location
    CNY
    MS-Off Ver
    Excel 2010
    Posts
    2

    macros disappear in excel 2010

    I have a file with 4 macros I have recorded. I use the file regularly but recently when I open it the macros are gone. it is saved as .xlsm.

    I am running windows 7 64 bit, the only recent change is I installed SoftEther VPN server and client.

    The microsoft site is useless, and have found no solutions. I can find my XLSTART folder but it is empty.

    for now I am exporting the module.bas files from the vba editor to a folder, and also storing the code in .txt files, so I have two backups which I can either import into the vba editor or paste from the text files.

    any suggestions appreciated, thanks

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: macros disappear in excel 2010

    Welcome to the forum

    One way in which macros appear to disappear is where they are stored in a different file to the one you meant to store them. That could be what happened here.

    If you have 2 files open at the same time it is possible to
    - create a macro in one file and
    - run it against the data in another file
    - you can save VBA in any open workbook
    - you can run VBA contained in any open workbook from any other open workbook

    The macro works and the results are what you expect
    - but the next time you open the file with the data, the macro is not there.

    My first guess is that is what you have done
    - I have done it myself and been very puzzled later
    - then days later I have found the VBA in another file!

    My suggestion is that you only have one file open when you create the macros, then save the workbook
    - try that and see if your macros disappear.

    [If you want to create a macro in one file to run against the data in another file, then please explain in more detail what you are trying to do]

    [If you want to use your Personal.xlsb file to hold macros that are available whenever you open Excel, then again please explain what you are trying to achieve]
    Last edited by kev_; 01-07-2018 at 12:59 PM.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  3. #3
    Registered User
    Join Date
    08-22-2012
    Location
    CNY
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: macros disappear in excel 2010

    it could be that I had 2 files open, I will keep that in mind. But shouldn't I then be able to find the macro in the dropdown Macros in: all open workbooks?

    I was looking in personal.xslb because other searches suggested that you could find your macros in the XLSTART folder.

    Thanks for the help.

  4. #4
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: macros disappear in excel 2010

    You would see the macro if the actual workbook containing the macro is open, otherwise not.

    When I get back to my PC I will update the thread with where to find your Personal.xlsb file
    - it varies depending on versions

  5. #5
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: macros disappear in excel 2010

    Some short videos from Excel Campus that may be helpful

    1 How to create a Personal Macro Workbook

    2 How to locate a Personal Macro Workbook
    Last edited by kev_; 01-08-2018 at 03:59 AM.

+ 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. Buttons disappear when rows are hidden/unhidden in 2010
    By natefarm in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 01-15-2016, 06:15 AM
  2. Arrow on drop down menu disappear (excel 2010) 2 SAMPLES PICT FOR TESTING (C:\COLOUR\)
    By bonaparte2459 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-23-2015, 10:32 PM
  3. Error calling Outlook 2010 macros from Excel 2010
    By MitcheMJ in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-11-2013, 04:48 PM
  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. [SOLVED] Excel 2010 - Rows disappear when using filters
    By BwestOZ in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-28-2012, 01:22 AM
  6. Replies: 0
    Last Post: 03-27-2012, 12:09 PM
  7. excel 2010 activex controls disappear in hidden rows
    By mardyl in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-28-2012, 09:38 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