+ Reply to Thread
Results 1 to 2 of 2

Macros disappear

  1. #1
    Registered User
    Join Date
    12-29-2019
    Location
    Nijmegen, Netherlands
    MS-Off Ver
    Office 365
    Posts
    31

    Macros disappear

    Hi,
    I was helping my daughter by making macro's on her PC. She's working at home with Office 365 from her boss.
    I made the first macro and the worksheet was presented by an app (no clue what that app does). The macro's have to be for her working on any workbook that she opens, general.
    Storing this first macro was only possible with the worksheet or on her personal storage. When I made the second macro on a different worksheet, storage was different; it was (what I was used to see) on the workbook or in general.
    The first macro didn't show up anymore. It seems that the two workbooks are on different Office platforms or configurations. Anyone ever experienced this and knows what you can do to avoid this?

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

    Re: Macros disappear

    It's hard to tell from this description exactly what you did. It sounds like you created the first macro, and saved it to that workbook. Then you created a second macro in a second workbook. Then the first macro will no longer be visible when you are working on the second workbook.

    The usual way to deal with this is to put macros in the PERSONAL.xlsb file, which is always open (and hidden). But then the macros will not be on her work PC. They would have to be copied there. Or you could create another file just with the macros, and copy that to the work computer.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Excel Macros Disappear
    By zanderaruba in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-07-2021, 07:28 PM
  2. Macros disappear unpredictably
    By backdrop in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-06-2019, 05:44 PM
  3. macros disappear in excel 2010
    By steve_w in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-08-2018, 02:21 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. 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