Closing workbook without saving changes

's Computer Specifications

I want to perform some cheks on workbook, afterthis I want to discard the
changes done on the workbook. I want it without input from user.

Thanks for the help in advance

's Computer Specifications

sorry got the wrong line
ThisWorkbook.Close (SaveChanges = True)
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"kris" wrote:

> I want to perform some cheks on workbook, afterthis I want to discard the
> changes done on the workbook. I want it without input from user.
>
> Thanks for the help in advance

's Computer Specifications

Add this to the end of your code
ThisWorkbook.Close (SaveChanges = False)
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"kris" wrote:

> I want to perform some cheks on workbook, afterthis I want to discard the
> changes done on the workbook. I want it without input from user.
>
> Thanks for the help in advance

's Computer Specifications

Thanks very much this is what i wanted

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Closing workbook without saving clipboard	mcalex	Microsoft Excel Programming	1	19th Mar 2004 02:18 AM
Closing Workbook without Saving	Chris Gorham	Microsoft Excel Programming	2	11th Dec 2003 12:17 AM
Re: saving workbook upon closing program	Alan	Microsoft Excel Worksheet Functions	2	6th Nov 2003 11:24 PM
Closing workbook without saving changes	EP	Microsoft Excel Worksheet Functions	2	10th Oct 2003 12:34 PM
Closing a workbook without saving	Darrin Henry	Microsoft Excel Programming	2	24th Sep 2003 02:31 PM