Hey guys,

have an excel program that loads data entered and saves in a separate sheet

all works well when run from excel alone, but when linked to a website and opened, as it opens in a new IE tab, the close function is no longer working, the workbook stays open.

Currently 
ActiveWorkbook.Close savechanges:=True
What else can I add to ensure, that if the workbook is open in an IE tab, it closes that IE tab after it saves?

Thanks