Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / May 2008

Tip: Looking for answers? Try searching our database.

Macro & "personal" sheet annoying!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
annoni - 28 May 2008 17:40 GMT
Everytime I open excel program, a sheet named "Personal" automatically opens.
I think this is happening since I have used macro feature once before.  
Could anybody help this sheet not to open?  Thanks.
Ron de Bruin - 28 May 2008 17:44 GMT
This is normal a hidden workbook that you use to store macros
that you want to use in all your workbooks

You can hide it like this

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.

Signature

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

> Everytime I open excel program, a sheet named "Personal" automatically opens.
> I think this is happening since I have used macro feature once before.  
> Could anybody help this sheet not to open?  Thanks.
Kevin B - 28 May 2008 17:51 GMT
Depending on whether or not you're on a network, the folder where the
PERSONAL.XLS file resides in either of the following folders:

Network
C:\Documents and Settings\UserID\Application Data\Microsoft\Excel\XLSTART

Where UserID is your network login id.  

Local:
C:\Documents and Settings\Application Data\Microsoft\Excel\XLSTART

Open My Computer or the Windows Explorer, locate the correct directory and
delte the file.

Signature

Kevin Backmann

> Everytime I open excel program, a sheet named "Personal" automatically opens.
>  I think this is happening since I have used macro feature once before.  
> Could anybody help this sheet not to open?  Thanks.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.