Personal File Link with Worksheet

M

Mervyn Thomas

With Office 2007 I am finding that the personal file is not directly linked
with the main spreadsheet so that when I close the main spreadsheet the
personal file is still open and requires to be closed seperately. Is there
a way to fix this?
Mervyn
 
J

Jim Rech

I am finding that the personal file is not directly linked with the main
I don't know what 'the main spreadsheet' is but Personal.xls is designed to
open with Excel (hidden) and stay open until Excel closes. The point being
to hold 'personal' macros that can be used with any workbook.

--
Jim
| With Office 2007 I am finding that the personal file is not directly
linked
| with the main spreadsheet so that when I close the main spreadsheet the
| personal file is still open and requires to be closed seperately. Is
there
| a way to fix this?
| Mervyn
|
|
 
M

Mervyn Thomas

Jim - I mean the workbook that is openeded by name with " Personal" opening
at the same time. When the workbook is closed Personal stays open and has to
be closed seperately!!
 
R

Ron de Bruin

Personal is visible ?

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.

See also
http://www.rondebruin.nl/personal.htm
 
Top