| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Closing workbook without saving changes
Thanks very much this is what i wanted
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 aborts randomly when closing/saving workbook | Excel Programming | |||
| Closing a workbook without saving from Word | Excel Programming | |||
| closing excel after closing a workbook | Excel Programming | |||
| Closing Workbook without Saving | Excel Programming | |||
| Closing a workbook without saving | Excel Programming | |||
Hybrid Mode
