+ Reply to Thread
Results 1 to 2 of 2

Can't find PERSONAL.XLSB

Hybrid View

psychson Can't find PERSONAL.XLSB 05-17-2013, 01:47 PM
scott.s.fower Re: Can't find PERSONAL.XLSB 05-17-2013, 04:59 PM
  1. #1
    Registered User
    Join Date
    02-29-2008
    Posts
    14

    Question Can't find PERSONAL.XLSB

    Hi.
    I'm new to macros and I may not have the complete understanding yet.
    I'm trying to locate PERSONAL.XLSB to copy macros and save them to use in different workbooks, however I can't find it.
    I think the reason is because my Excel is on a network and my files are accessed on a server. I already look the possible paths.
    It may be a dumb question, but here it goes:
    Is there anyway I can save my macros if I can't locate PERSONAL.XLSB or do I have to ask for the folder/file to my IT manager ?
    I'm using old excel 2003.

    Thanks.

  2. #2
    Valued Forum Contributor
    Join Date
    11-20-2012
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2010
    Posts
    597

    Re: Can't find PERSONAL.XLSB

    there should be an option in your settings that says, At startup, open all files in: you can make your own folder and create PERSONAL.XLSB or another .XLSB to save your macros in, you can save macros in any macro enabled workbook, so I don't really use PERSONAL.XLSB, I use SCOTT.XLSB instead for my macros, and I use TEST.XLSB for macros that aren't quite ready yet so I can keep my SCOTT.XLSB clean

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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