Results 1 to 14 of 14

Thread: [RESOLVED] $%%$$%# Personal.xlsb

  1. #1

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,427

    Resolved [RESOLVED] $%%$$%# Personal.xlsb

    As an experiment I created a Personal.xlsb file for myself to see what it was like using one. I wasn't happy with the results so I deleted it. After that it doesn't show up in my VBAProject window until I record a macro. How do I stop Excel from recreating it?

  2. #2
    PowerPoster jdc2000's Avatar
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    2,392

    Re: $%%$$%# Personal.xlsb


  3. #3

  4. #4
    PowerPoster jdc2000's Avatar
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    2,392

    Re: $%%$$%# Personal.xlsb

    What part of that did not help? If you have macros in Excel, that file will exist, although it is normally hidden.

    https://www.excelvbasolutions.com/20...xlsb-file.html

    https://answers.microsoft.com/en-us/...a-89faa03116b9

    https://howtoexcelatexcel.com/vba/ma...acro-workbook/

  5. #5
    Fanatic Member Delaney's Avatar
    Join Date
    Nov 2019
    Location
    Paris, France
    Posts
    845

    Re: $%%$$%# Personal.xlsb

    Hello,

    I think you cannot prevent that as it is the file in which Excel put the macros . https://bettersolutions.com/excel/ma...sonal-xlsb.htm
    The best friend of any programmer is a search engine
    "Don't wish it was easier, wish you were better. Don't wish for less problems, wish for more skills. Don't wish for less challenges, wish for more wisdom" (J. Rohn)
    “They did not know it was impossible so they did it” (Mark Twain)

  6. #6

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,427

    Re: $%%$$%# Personal.xlsb

    If you have macros in Excel, that file will exist, although it is normally hidden.
    That's not True. For 10+ years I recorded macros and they always recorded in the current workbook and Personal.xlsb was not in my VBAProject window.

    What didn't work was clicking 'Hide' as suggested in the article caused both my current workbook and, supposedly, Personal.xlsb to be hidden. I say supposedly because Personal.xlsb was still in my VBAProject window.

    I'll take a look at the other links.

  7. #7

  8. #8

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,427

    Re: $%%$$%# Personal.xlsb

    jdc2000 your other 3 links talk about deleting it but I already did that. After that it comes back when I record a macro. I'm guessing now that there's some registry setting I set to "On" when I created my first Personal.xlsb file.

  9. #9
    PowerPoster jdc2000's Avatar
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    2,392

    Re: $%%$$%# Personal.xlsb

    Try a System Restore to a point before you created the file.

  10. #10
    PowerPoster jdc2000's Avatar
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    2,392

  11. #11
    Fanatic Member Delaney's Avatar
    Join Date
    Nov 2019
    Location
    Paris, France
    Posts
    845

    Re: $%%$$%# Personal.xlsb

    Did you check where you are recording your macro ? are you sure it is in the current workbook and not in the personal-xlsb file? that's maybe why it recreates it .
    The best friend of any programmer is a search engine
    "Don't wish it was easier, wish you were better. Don't wish for less problems, wish for more skills. Don't wish for less challenges, wish for more wisdom" (J. Rohn)
    “They did not know it was impossible so they did it” (Mark Twain)

  12. #12

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,427

    Re: $%%$$%# Personal.xlsb

    Try a System Restore to a point before you created the file.
    Impractical.
    id you check where you are recording your macro ? are you sure it is in the current workbook and not in the personal-xlsb file?
    Absolutely. As I said, I was recording macros (and looking for then) for over 10 years until I manually created my first Personal.xlsb file,

  13. #13
    PowerPoster
    Join Date
    Nov 2017
    Posts
    3,116

    Re: $%%$$%# Personal.xlsb

    Make sure no Excel processes are running.

    In Regedit, go to:

    HKCU\Software\Policies\Microsoft\Office\##.0\excel\options\binaryoptions

    The ## will vary (14.0, 15.0, 16.0) depending on what version of Office you have.

    If there is a value in the above key named "fglobalsheet_37_1" with a value of 1, try changing it to a 0.

  14. #14

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,427

    Re: [RESOLVED] $%%$$%# Personal.xlsb

    I believe I found the solution and it's kind of embarrassing but I think I owe it to the people who tried to help me and explain what the problem was.

    As I mentioned above I've worked with Excel and recorded macros for over 10 years and never had a problem with Personal.xlsb popping up until i once purposely created that file. Prior to that when I recorded a macro I never looked in the 'Store macro in' dropdown and so the default was 'This workbook'. Once I created Personal.xlsb the default changed to 'Personal Macro Workbook' and I never noticed that either, so recording a macro would recreate the file. Once I deleted Personal.xlsb and recorded a macro making sure that I first chose 'This workbook', that became the default again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width