thanks for the response.
i gave it a try;
Set y = ThisWorkbook.Sheets("MS Project").OLEObjects(1)
y.Verb
Set y = Nothing
but MS Project is still running.

Project 2003, Excel 2003


"Bob Phillips" wrote in message
...
Set y = Nothing

--

HTH

RP
(remove nothere from the email address if mailing direct)


"greg" wrote in message
...
Hello,
I have an excel worksheet with an embedded MS Project file.
to get at the ms project i do the following:
Set y = ThisWorkbook.Sheets("MS Project").OLEObjects(1)
y.Verb
but how can i de-activate it?
thanks