?

Log in

No account? Create an account
entries friends calendar profile http://web.figure1.net/~jlindqui Previous Previous Next Next
Useful Excel Tip of the Day - Jason Lindquist
Idle ramblings of an idle mind
jlindquist
jlindquist
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.
Leave a comment