Hi, Belinda. This is a machine setting (whether IE or Excel is used to open
a workbook on a website), and I don't believe that it's controllable with
VBA or any other kind of script.
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Web: New! www.VBAExpress.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->

Just put the workbook on the server and on any page a link to it as you
would a link to anything else, for example, <a href="xyz.xls">Here's
the XL workbook</a>  What happens next depends on the visitor.  If XL
is installed on their machine and tney just click on the link, and
various file associations are set correctly, XL will indeed start up
and open the file.  However, I, for one, would never click on a link
and open a workbook 'automatically.'  If I decide I want to look at the
file, it would be downloaded to my computer and checked for viruses
before being opened with macros disabled.