Hey Peeps,

I am opening an excel document in a html frame in internet explorer and then
using the below macro within the excel workbook to control the value of a
cell. Once i either close the window or move to another page in internet
explorer the Excel process (in task manager) keeps running and so i can't
open the file again as it says its already open.

The macro that is activated when i click on a link is below:



Sub link1()

ActiveSheet.Unprotect
temp = ActiveWorkbook.Sheets("Sheet2").Range("B1").Value
ActiveWorkbook.ActiveSheet.Range("description").Va lue = temp
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True

End Sub



Regards

Adam Thickett