Jason Lindquist (jlindquist) wrote,
Jason Lindquist

Useful Excel Tip of the Day

If you have a macro you would like available to all workbooks you open in Excel, save it in a workbook located in C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART\personal.xls.

This is useful if, say, your department minion sends out spreadsheets showing everybody's training requirements, and you'd prefer to extract just the new ones that apply to you. And you know that convincing her to include your macro in her spreadsheet is unlikely to succeed.

Really, it's a place to put your VBA macro toolbox.

  • 2 Legit 2 Quit video

    In November of our senior year of high school, Zach Klein and Chris Collins put together a music video for our basketball team. Most of it was…

  • (no subject)

    They charged two parents with providing alcohol to minors and allowing underage consumption today. We all knew that was coming, and that is as it…

  • Aurora reference

    For reference, the only two links I could find on Aurora shooter (and Westview '06 grad) James Holmes, prior to his attendance at Westview being…

  • Post a new comment


    default userpic

    Your reply will be screened

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.