Closing workbook without saving changes
 

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

Closing workbook without saving changes
 

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

Closing workbook without saving changes
 

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

Closing workbook without saving changes
 

Thanks very much this is what i wanted