+ Reply to Thread
Results 1 to 4 of 4

Personal Macro workbook does not start

  1. #1
    Forum Contributor
    Join Date
    09-03-2004
    Location
    Vancouver, BC Canada
    Posts
    136

    Personal Macro workbook does not start

    Hi All,
    I have recorded a few macros in my personal workbook but when I restart my excel, the personalworkbook does not show up. If however, I start recording a new Macro, then the personal macro workbook does show up. I have checked the Addins to see if it is disabled, and also checked the trust centre to figure out but I'm unable to understand as to why it is not showing up. Any help would be greatly appreciated!

    Thx

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Personal Macro workbook does not start

    When you click on Alt +F11 do you see the modules in the VBE? If so, then the workbook is opening, but is hidden. If you want to unhide it, click on the view tab in the ribbon and click on unhide.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    09-03-2004
    Location
    Vancouver, BC Canada
    Posts
    136

    Re: Personal Macro workbook does not start

    Hi,
    Thanks for the response. When I open the VBE, the personal macro work book does not show up. Not sure what has happened!
    Best,
    Kollur

  4. #4
    Forum Expert
    Join Date
    10-02-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1,222

    Re: Personal Macro workbook does not start

    The most likely reason is you have an unclosed process of Excel lingering around. Close Excel entirely, check task manager in Windows to see if there are any left over Excel.exe entries, if so end them. Otherwise try a reboot of the machine.

    You can check in the XLSTART folders and make sure you dont have multiple personal.xlsb files, if so consolidate them or move them and recreate a new single personal.xlsb. Similarly, if you have other files in the XLSTART folders move them out until you get the personal workbook figured out.

    Is this something that worked once and has since stopped working or have you never had the personal workbook open properly? Its possible if this is a work machine that the internal IT dept has blocked this file, forcefully deleting it after its created. I have seen this in a few cases. If it has never worked right I would check if any colleagues either have personal workbooks that work or if they can try and test it, if no one does then check with your IT people presuming this is at work.

    You can also try disabling addins. I would start by opening Excel in safe mode, then closing and opening it normally. If that works it was likely a temporary issue caused by an addin or template. If not, then disable all addins and open normally. If it works enable addins 1 by 1 (close and reopen after enabling each) until the problem comes up again or you have re-enabled all addins. This way you can narrow down which addin(s) are causing a problem and either disable them or if they are needed troubleshoot them (update them, newer version, alternative, etc.)
    Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.

    "I am here to help, not do it for people" -Me

+ 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. Replies: 1
    Last Post: 10-10-2015, 01:00 AM
  2. Personal Macro Workbook
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-23-2010, 03:15 AM
  3. Running workbook macro from personal workbook
    By mashley in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-10-2009, 08:44 AM
  4. personal macro workbook
    By jazbath in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-10-2009, 03:17 AM
  5. No Personal Macro Workbook?
    By Kou Vang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2006, 01:10 PM
  6. [SOLVED] Personal macro workbook and personal.xls
    By John Kilkenny in forum Excel General
    Replies: 1
    Last Post: 06-14-2005, 05:05 PM
  7. [SOLVED] Personal Macro Workbook
    By Ivor Williams in forum Excel General
    Replies: 1
    Last Post: 03-21-2005, 12:06 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