ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   "Personal.xls" Page (https://www.excelbanter.com/excel-discussion-misc-queries/136238-personal-xls-page.html)

k'lyn

"Personal.xls" Page
 
While taking an online class in Excel I learned to create macros. Now, every
time I launch Excel, it opens Personal.xls instead of a blank worksheet - or
it loads it first before the other document I am trying to open.

Why? and how do I go back/stop it?

R1C1

"Personal.xls" Page
 
While learning to create macros, you probably recorded a macro. When you
recorded macro, a Personal.xls file was created on your computer. This file
is usually hidden. If you plan on continuing your education with macros, I
suggest you hide the Personal.xls workbook. With Personal.xls in the Active
Window, choose Window on your toolbar, then choose Hide. Close Excel and say
Yes to save changes to your Personal.xls. The next time you open Excel, the
workbook will be hidden and you can continue to record and learn VBA.

Regards,

Alan


"k'lyn" wrote in message
...
While taking an online class in Excel I learned to create macros. Now,
every
time I launch Excel, it opens Personal.xls instead of a blank worksheet -
or
it loads it first before the other document I am trying to open.

Why? and how do I go back/stop it?




Dave Peterson

"Personal.xls" Page
 
First, you'll want to decide if you want to keep those macros you created in
personal.xls.

If you do, then open excel (let personal.xls open).

Then with personal.xls the active workbook, do Window|Hide.
Then close excel.
You'll be prompted to see if you want to save personal.xls (since you changed it
by hiding it).
Answer yes.

Now when you open excel, personal.xls will open (and you'll hae access to its
macros), but it will be hidden and less irritating.

If you don't want the macros that you created, then you can delete personal.xls
from your computer.

Close excel
Use windows start button|Search to find personal.xls
remember to look in hidden folders, too.

Then delete it (or maybe move it to a nice safe location--if you might change
your mind later).

Then open excel to test it out.

k'lyn wrote:

While taking an online class in Excel I learned to create macros. Now, every
time I launch Excel, it opens Personal.xls instead of a blank worksheet - or
it loads it first before the other document I am trying to open.

Why? and how do I go back/stop it?


--

Dave Peterson


All times are GMT +1. The time now is 06:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com