PDA

View Full Version : Solved: dont save a window



Klartigue
10-20-2011, 08:18 AM
Sub CloseSecInfo()
Windows("sec.info.xlsx").Activate
ActiveWindow.Close
End Sub

When i am closing this window, a save or dont save window pops up. How do i automatically say dont save in the macro?

Aflatoon
10-20-2011, 08:28 AM
Sub CloseSecInfo()
Workbooks("sec.info.xlsx").Close Savechanges:=False
End Sub
should be sufficient.

Klartigue
10-20-2011, 08:38 AM
thank you! that works great