ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Close without save (https://www.excelbanter.com/excel-programming/297543-close-without-save.html)

Jesse[_5_]

Close without save
 
Hi, Thanks in advance for any help. I need to close a
sheet without saving so as not to get the popup windows
for save as. I did make a change to the sheet, but do not
need to save this data.

Jesse

Dick Kusleika[_3_]

Close without save
 
Jesse

Try here

http://www.dicks-blog.com/excel/2004...g_a_workb.html

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Jesse" wrote in message
...
Hi, Thanks in advance for any help. I need to close a
sheet without saving so as not to get the popup windows
for save as. I did make a change to the sheet, but do not
need to save this data.

Jesse




mudraker[_205_]

Close without save
 
Jesse

I assume you are wanting VBA code to close your workbook

Workbooks("BOOK1.XLS").Close SaveChanges:=Fals

--
Message posted from http://www.ExcelForum.com


Jesse[_6_]

Close without save
 
Thanks Dick,

Works great. Really appreciate the help.

Jesse

-----Original Message-----
Jesse

Try here

http://www.dicks-

blog.com/excel/2004/04/closing_a_workb.html

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Jesse" wrote in

message
...
Hi, Thanks in advance for any help. I need to close a
sheet without saving so as not to get the popup windows
for save as. I did make a change to the sheet, but do

not
need to save this data.

Jesse



.



All times are GMT +1. The time now is 05:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com