Macro on Personal Workbook

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
 
R

Ron de Bruin

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.
 
S

Stacey Crowhurst

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.
 
C

CurlyDave

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top