Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Kansas, USA
    Posts
    73
    Thanks
    0
    Thanked 0 Times in 0 Posts

    personal.xls (Excel2000)

    I got a new computer with WinXP Pro and I am wondering where do I put the personal.xls folder. I put it in C:Program FilesMicrosoft OfficeOffice2000OfficeXLStart, but when I run a macro that opens a worksheet, it is always asking for a location for that file.

    Also, I can't edit a macro because it says I must unhide it, but it's not open.

  2. #2
    New Lounger
    Join Date
    Jan 2002
    Location
    UK
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: personal.xls (Excel2000)

    Gary,

    If you record a macro (anything will do) and specify 'personal macro workbook' in the Record Macro dialog box, then Excel will automatically create a personal.xls file. This is the easiest way of doing it.

    On my machine personal.xls can be found on my machine (XPpro / XL2k) in:
    Cocuments and SettingsNickApplication DataMicrosoftExcelXLSTARTPERSONAL.XLS
    (Nick being my user name)

    HTH,

    Nick

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: personal.xls (Excel2000)

    <I can't edit a macro because it says I must unhide it, but it's not open>

    Try the Window menu and see if there is an option to Unhide. If so select it and see what files are open but hidden.

    You can also edit macros in hidden workbooks (unless they protected) from the VBA environment (Alt-F11).

    Andrew C

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: personal.xls (Excel2000)

    Press Alt+F11 to open the VBA Editor. Look in the project explorer on the left side of the window to see if there is a Personal.xls open. The workbook can be hidden and you can still edit macos in it.
    Legare Coleman

Posting Permissions

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