Macro on Personal Workbook

  • Thread starter Thread starter Stacey Crowhurst
  • Start date Start date
S

Stacey Crowhurst

Hi. I have created a few macros and saved them to my personal workbook. Now
every time I open an excel file, the worksheet opens and the perosonal
worksheet opens. Can I change something so that the personal one doesn't
open? Also, somewhere along the line I accidentally saved another personal
worksheet "8.xls" so now all three open: 1. my file 2. personal.xls and 3.
8.xls.

Any help is appreciated!
Thanks,
Stacey
 
Hi Stacey

Close Excel
Goto this folder

C:\Documents and Settings\Ron\Application Data\Microsoft\Excel\XLSTART
In Vista look here
C:\Users\Ron\AppData\Roaming\Microsoft\Excel\XLSTART

Remove 8.xls and my file ?

Open Excel

Then do this to hide the personal file :

When you open Excel and you see PERSONAL.XLS(B) in the title bar you can use this to hide it.

Excel 97-2003: Window>Hide
Excel 2007 : On the View tab in the window group choose Hide

Then close Excel and say Yes to save the changes to your PERSONAL file.
 
Yup. That did it. Thanks for your help!

Ron de Bruin said:
Hi Stacey

Close Excel
Goto this folder

C:\Documents and Settings\Ron\Application Data\Microsoft\Excel\XLSTART
In Vista look here
C:\Users\Ron\AppData\Roaming\Microsoft\Excel\XLSTART

Remove 8.xls and my file ?

Open Excel

Then do this to hide the personal file :

When you open Excel and you see PERSONAL.XLS(B) in the title bar you can use this to hide it.

Excel 97-2003: Window>Hide
Excel 2007 : On the View tab in the window group choose Hide

Then close Excel and say Yes to save the changes to your PERSONAL file.
Click to expand...
 
Hi.  I have created a few macros and saved them to my personal workbook..  Now
every time I open an excel file, the worksheet opens and the perosonal
worksheet opens.  Can I change something so that the personal one doesn't
open?  Also, somewhere along the line I accidentally saved another personal
worksheet "8.xls" so now all three open: 1. my file 2. personal.xls and 3..
8.xls.

Any help is appreciated!
Thanks,
Stacey
Click to expand...

When you are in your personal workbook
Go to the top menu and select the Window menu and choose Hide
 
Back
Top