+ Reply to Thread
Results 1 to 2 of 2

Excel MAC: Cannot record a personal Macro

  1. #1
    Registered User
    Join Date
    08-08-2018
    Location
    Bangkok
    MS-Off Ver
    2016
    Posts
    58

    Excel MAC: Cannot record a personal Macro

    As in the screenshot attached it tells me:

    "Personal Macro Workbook in the startup folder must stay open for recording" and "Unable to record"

    I tried to click the View --> Unhide but it is greyed out

    All the help online is for Excel windows. I use excel MAC 365 version 16.61

    Thanks
    Attached Images Attached Images

  2. #2
    Valued Forum Contributor
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    797

    Re: Excel MAC: Cannot record a personal Macro

    Maybe you can try this procedure:

    Please try the following steps to check the result:

    1) Go to Finder and type "startup" into the search box

    2) Open the STARTUP folder and choose Excel folder to check whether you can see the personal.xlsb or not.

    3) If it is available, then double click and open and restart Excel.
    Source:
    https://answers.microsoft.com/en-us/...8-f9a907fedd2b

    By the way, please update your forum profile to reflect the current version of excel (Mac 365) that you now have.
    Last edited by janmorris; 04-25-2022 at 10:56 PM.
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

+ 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. Not able to record macro to Personal Macro Workbook
    By dominicm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-20-2017, 05:17 AM
  2. [SOLVED] Error message when trying to record a macro - No Personal Macro Workbook
    By KimC in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2014, 06:56 PM
  3. Excel's Personal Macro Workbook
    By Excel User in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-26-2006, 03:20 PM
  4. [SOLVED] Personal Immunization record
    By DOCTORMOM457 in forum Excel General
    Replies: 0
    Last Post: 01-12-2006, 02:40 PM
  5. record Personal Macro Workbook
    By John Fitzgerald in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-08-2005, 11:05 AM
  6. [SOLVED] Excel Starts up w/a Personal Macro page
    By Parker in forum Excel General
    Replies: 4
    Last Post: 08-29-2005, 05:05 PM
  7. [SOLVED] Personal macro workbook and personal.xls
    By John Kilkenny in forum Excel General
    Replies: 1
    Last Post: 06-14-2005, 05:05 PM

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