Close without Saving In VBA
 

Is there something I can add to the following code to make the workboo
close without asking if I want to save?

ActiveWindow.Close

Thanks in advance!

Celtic_Avenger
:confused

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

Close without Saving In VBA
 

ActiveWindow.Close Fals

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

Close without Saving In VBA
 

That simple................Thanks ya a star!

You know I tried everything else I could think of.......and it turne
out to be that simple.

What they say is true........."You only know it if you know it!"

Cheers!

Celtic_Avenge

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

Close without Saving In VBA
 

Hi Celtic_Avenger

You would know too if you have intellisence turned on.

While in the VBA Editor.
Tools Options Editor Tab

Then click

Auto list members
Auto quick info

Also highligting key words and pressing F1 gives you the help on
that key work if avail.
MS Help is very much under utilised

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