PC Review


Reply
Thread Tools Rate Thread

How do I get rid of the PERSONAL.XLS sheet from a workbook?

 
 
Arencia
Guest
Posts: n/a
 
      5th Jan 2010
Everytime I want to "X" out of excel, I always have to also close the
PERSONAL.XLS sheet
 
Reply With Quote
 
 
 
 
Bernard Liengme
Guest
Posts: n/a
 
      5th Jan 2010
Normally the Personal file is hidden
If you use Windows | Hide then you will never need to close it again
OR you could locate it in the XLSTART folder and just delete it - hope it
has no macros that you need to use
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Arencia" <(E-Mail Removed)> wrote in message
news:9E91F069-881E-4D83-A224-(E-Mail Removed)...
> Everytime I want to "X" out of excel, I always have to also close the
> PERSONAL.XLS sheet


 
Reply With Quote
 
Ron de Bruin
Guest
Posts: n/a
 
      5th Jan 2010
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.


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Arencia" <(E-Mail Removed)> wrote in message news:9E91F069-881E-4D83-A224-(E-Mail Removed)...
> Everytime I want to "X" out of excel, I always have to also close the
> PERSONAL.XLS sheet

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Save each sheet of multi-sheet workbook as a single-sheet workbook CTB Microsoft Excel Programming 3 17th May 2011 08:40 AM
Re: Update Personal Workbook Macros when Workbook is opened. RyanH Microsoft Excel Programming 4 22nd Aug 2008 04:57 PM
Personal macro workbook and personal.xls =?Utf-8?B?Sm9obiBLaWxrZW5ueQ==?= Microsoft Excel Misc 1 14th Jun 2005 09:43 PM
Calling a Personal.XLS Sub from anther workbook's 'This Workbook' Sheet Activate Jack Gillis Microsoft Excel Discussion 2 21st Mar 2005 11:58 PM
How to handle other workbook events through personal.xls workbook ivarsb Microsoft Excel Programming 1 27th Jul 2004 01:35 PM


Features
 

Advertising
 

Newsgroups
 


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