Close Personal.xls after each macro

's Computer Specifications

Hello all,

Everytime I run a macro it opens my PERSONAL.xls sheet. I would like to
write code at the end of each macro which closes Personal.xls. What would
the code look like to do that? Thanks

Brennan

's Computer Specifications

Personal.xls should always be open when there's an instance of Excel
running...do you mean that Personal.xls is visible after each macro?
If so just go Window>Hide to keep it hidden.

Cliff Edwards

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: How does Personal Macro Workbook become personal.xls	AB	Microsoft Excel Programming	3	27th Apr 2010 08:55 PM
Can I stop the close method in an auto close macro	=?Utf-8?B?UGF1bA==?=	Microsoft Excel Programming	2	17th Nov 2006 02:48 PM
Don't let user close. Use macro button to close?	mike	Microsoft Excel Programming	2	30th Oct 2006 01:31 PM
Personal macro workbook and personal.xls	=?Utf-8?B?Sm9obiBLaWxrZW5ueQ==?=	Microsoft Excel Misc	1	14th Jun 2005 09:43 PM
Can't Close a Personal Folder	Mike M	Microsoft Outlook Interoperability	1	23rd Sep 2003 05:54 AM