Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opposite of Application.SaveWorkspace
When I close a woorkbook, it asks me if I want to save. I know I
don't, and it is very important that other ppl that I give the workbook to don't either. In fact it's also better if they don't have a choice to. Is there a line of code say opposite to Application.SaveWorkspace, that will disallow a save? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opposite of Application.SaveWorkspace
If you're closing a workbook, you can use:
dim wkbk as workbook set wkbk = workbooks("book1.xls") 'do lots of stuff wkbk.close savechanges=false to avoid that question. Rich wrote: When I close a woorkbook, it asks me if I want to save. I know I don't, and it is very important that other ppl that I give the workbook to don't either. In fact it's also better if they don't have a choice to. Is there a line of code say opposite to Application.SaveWorkspace, that will disallow a save? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opposite of Countifs | Excel Worksheet Functions | |||
opposite of concatenate? | Excel Discussion (Misc queries) | |||
opposite of IsNumeric | Excel Discussion (Misc queries) | |||
opposite to Application.Saveworkspace | Excel Programming | |||
macro to close excel application other than application.quit | Excel Programming |