[VBA]Sub CloseSecInfo()
Windows("sec.info.xlsx").Activate
ActiveWindow.Close
End Sub[/VBA]
When i am closing this window, a save or dont save window pops up. How do i automatically say dont save in the macro?
[VBA]Sub CloseSecInfo()
Windows("sec.info.xlsx").Activate
ActiveWindow.Close
End Sub[/VBA]
When i am closing this window, a save or dont save window pops up. How do i automatically say dont save in the macro?
[vba]
Sub CloseSecInfo()
Workbooks("sec.info.xlsx").Close Savechanges:=False
End Sub[/vba]
should be sufficient.
Be as you wish to seem
thank you! that works great
Posting Permissions
Reply With Quote
