ActiveWindow.Close without popup?

[smakatura]

ActiveWindow.Close

The above code in my macro. When I use this command, it has a popup that asks me if I want to save my changes. I want it to not give me the popup and just close the file. I do not want to save my changes.

is there a command I can use that will just close the active window (without saving and without asking me via a popup)?

 

[Norie]

Are you actually closing a workbook?

If you are then if you used the Close method you could set the SaveChanges argument to False so you don't get that popup.

Workbooks("WorkbookToClose.xlsx").Close SaveChanges:=False

 

[VoG]

Try

ActiveWindow.Close savechanges:=False

 

[smakatura]

ActiveWindow.Close savechanges:=False

above code worked great.

I could not get the workbook coding to work.

but I am good now, thanks guys