+ Reply to Thread
Results 1 to 4 of 4

Not able to record macro to Personal Macro Workbook

  1. #1
    Registered User
    Join Date
    04-14-2010
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    21

    Not able to record macro to Personal Macro Workbook

    Hello,

    I am just about to start a macro project. I would like the macro to be stored in my personal macro workbook so I can run it on any workbook. When I have a workbook open I can select "Record New Macro" and under the "store macro in" dropdown box I can select "Personal Macro Workbook", when I click on "OK" a popup box appears saying, "Peronal macro workbook in the startup folder must stay open for recording", when I click on "OK" another popup box appears saying "unable to record". I'm not sure what to do to check the personal macro workbook is in the correct place or configured correctly such that I can record to it. Thanks for any help to get me going.

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Not able to record macro to Personal Macro Workbook

    Hi,

    Have you checked under the Manage AddIns section in Options to see if the Personal Macro Workbook has been disabled?
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Registered User
    Join Date
    04-14-2010
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    21

    Re: Not able to record macro to Personal Macro Workbook

    Hi thanks, I have looked in 'File, Options, Add-ins' and 'File, Options, Advanced' and can not see any reference anywhere to personal macro workbook to see if it is selected or not? I am running Excel from Microsoft office professional plus 2013. thanks

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Not able to record macro to Personal Macro Workbook

    Is there anything listed as disabled in File- Options- AddIns?

    Also, can you make sure that you do not have a Personal Macro Workbook in both your user XLSTART folder and the Program Files XLSTART folder?

+ 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. Manipulating ActiveWorkbook when calling macro from Personal Macro Workbook
    By 146considerations in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-05-2017, 12:16 AM
  2. Replies: 1
    Last Post: 10-10-2015, 01:00 AM
  3. [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
  4. Replies: 2
    Last Post: 08-13-2014, 06:39 PM
  5. Replies: 1
    Last Post: 08-13-2014, 05:46 PM
  6. Perform macro "on open" specific file- store macro in Personal Macro Workbook?
    By thompssc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2012, 12:38 PM
  7. record Personal Macro Workbook
    By John Fitzgerald in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-08-2005, 11:05 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