#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 24
Default personal.xls

Thanks to both of you. I have asked the question to several people with no
answers until now.

"Gord Dibben" wrote:

When you record a macro you have a choice of where to store that macro.

One choice is Persoanl Macro Workbook..........Personal.xls

This workbook opens when Excel is started.

It is designed this way so your macros are available for any and all open
workbooks.

You can hide it so's it opens in the background and you don't have to deal
with saving and closing it(unless you make changes to it)

Or if you don't need the macro(s), simply delete the workbook from your
XLSTART folder.


Gord Dibben MS Excel MVP

On Sat, 13 Mar 2010 07:46:01 -0800, wcurtis
wrote:

Why does Excel 2007 open two workbooks when I open one of my saved workbooks?
Whenever I open the workbook I want to work in, another book opens with
personal.xls as the name. After I save my work, I have to close two
workbooks, why is that?


.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
personal.xls Pat-southern-California Excel Worksheet Functions 15 July 7th 07 07:32 PM
WHERE IS PERSONAL.XLS Bob Phillips New Users to Excel 0 July 13th 05 10:45 AM
Personal macro workbook and personal.xls John Kilkenny Excel Discussion (Misc queries) 1 June 14th 05 09:43 PM


All times are GMT +1. The time now is 09:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"