how would i go about having a code that closes the worksheet, and does NOT save it
C choice Aug 14, 2004 #1 how would i go about having a code that closes the worksheet, and does NOT save it
D Dave Peterson Aug 15, 2004 #3 Another way to close a workbook without saving: dim wkbk as workbook set wkbk = workbooks("whatever.xls") '.... wkbk.close savechanges:=false
Another way to close a workbook without saving: dim wkbk as workbook set wkbk = workbooks("whatever.xls") '.... wkbk.close savechanges:=false