D
Don Guillett
Do a windows find for the file name
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gord Dibben
If you have one it will reside in
C:\Documents and Settings\username\Application\Data\Microsoft\Excel\XLSTART
Personal.xls is created the first time you record a Macro using Macro
Recorder.
Tools>Macro>Record New Macro. A dialog box will come up asking you name the
macro and where to place it. Pick Personal Macro Workbook from the dropdown.
Copy and paste a couple of cells then Stop Recording.
You now have a Personal.xls in your Office\XLSTART folder. You can go to
Visual Basic Editor(Alt+F11) to view the macro you just recorded in a Module.
You can add more macros by recording or by typing them into the Module.
You can do a File>Save from there or better yet hit ALT + Q to return to the
Excel window.
Then with Personal.xls active, hit Window>Hide.
When you close Excel you will be asked if you want to save Personal.xls. Yes!
It will open hidden next time you start Excel.
Gord Dibben Excel MVP
On Thu, 27 Jan 2005 14:03:01 -0800, MBH <[email protected]> wrote:
C:\Documents and Settings\username\Application\Data\Microsoft\Excel\XLSTART
Personal.xls is created the first time you record a Macro using Macro
Recorder.
Tools>Macro>Record New Macro. A dialog box will come up asking you name the
macro and where to place it. Pick Personal Macro Workbook from the dropdown.
Copy and paste a couple of cells then Stop Recording.
You now have a Personal.xls in your Office\XLSTART folder. You can go to
Visual Basic Editor(Alt+F11) to view the macro you just recorded in a Module.
You can add more macros by recording or by typing them into the Module.
You can do a File>Save from there or better yet hit ALT + Q to return to the
Excel window.
Then with Personal.xls active, hit Window>Hide.
When you close Excel you will be asked if you want to save Personal.xls. Yes!
It will open hidden next time you start Excel.
Gord Dibben Excel MVP
On Thu, 27 Jan 2005 14:03:01 -0800, MBH <[email protected]> wrote:
B
Bill Sharpe
Limit the search to your documents and settings folder first. If not
found, then look everywhere -- under the mouse, etc. <g>
Bill
Do a windows find for the file name
found, then look everywhere -- under the mouse, etc. <g>
Bill
Do a windows find for the file name
N
Nick Hodge
Providing there is no setting in Tools>Options>General>Alternate start-up
folder they should be somewhere like
C:\Documents and Settings\[UserName]\Application
Data\Microsoft\Excel\XLStart
Bear in mind folders below the user name are hidden by default and
personal.xls will only exist if you have set one up or recorded a macro to
it
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
folder they should be somewhere like
C:\Documents and Settings\[UserName]\Application
Data\Microsoft\Excel\XLStart
Bear in mind folders below the user name are hidden by default and
personal.xls will only exist if you have set one up or recorded a macro to
it
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]