Hi Kathleen,

I don't think you can disable the warning on a spreadsheet basis. The 
network may be clean / safe, but that doesn't say anything about the 
worksheet itself. The only thing I can think of is disabling the macro-
warning in Excel (and Word for that matter) but that has to be done by the 
client. After all, if you could disable the warning INSIDE the 
spreadsheet, how useful would the warning mechanism be?? A malicious user 
would disable the warning and present you with some nasty macros.

Is the Internet Explorer really closed, or are its contents just replaced 
by a spreadsheet?

When I open a spread-sheet on my computer, Internet Explorer stays open, 
but the spread-sheet is displayed inside the browser.

If you are just using client side stuff, I think not much can be done 
about it. One thing I can think of is adding a target attribute 
(target="_blank") to the hyperlink. This will open the spreadsheet in a 
new instance of IE, leaving the old one open.

If you are using ASP for example, you can force the browser to show the 
Save As dialog box by setting the content type of the response page (where 
you serve the spreadsheet) to an unknown type.  If that's the case, take a 
look at message 4 at http://p2p.wrox.com/archive/proasp_howto/2001-
01/85.asp for some more info on this.

Hope this helps,

Imar




> I have a link on my page to an Excel spreadsheet.  This spreadsheet 
> contains some self-contained (virus clean) macros.  When I click on the 
> link, I receive a message that states:
> "The workbook you are opening contains macros.  Some macros may contain 
> harmful viruses.  If you are sure this workbook is from a trusted 
source, 
> click Yes.  If you are not sure and want to prevent any macros from 
> running, click No."
> 
> When I choose YES, the Excel file opens and the IE 5.0 window closes.
> 
> I have two questions.
> 1.  Since this is an intranet site and all files are "safe", can this 
> message be disabled?
> 2.  Is there a way to open the spreadsheet and leave IE open 
> simultaneously?
> 
> My html looks like this.
> 
> <ul class=collapsed id=cba>
> <li>
>         <a href="e:\new project information\imp information\CBA 
> Information\CBA Information Document.doc">Cost Benefits Analysis 
> Document</a>
> </li>
> <li>
>         <a href="e:\new project information\imp information\CBA 
> Information\CBA template excel version.xls">Cost Benefits Analysis 
> Workbook</a>
> </li>
> <li>
>         <a href="e:\new project information\imp information\CBA 
> Information\Project Cost Estimation Shreadsheet.xls">Project Cost 
> Estimation Workbook</a>
> </li>
> </ul>