Robin Hammond wrote:
*1. change your security level settings. Probably not good.
2. create a digital certificate using selfcert.exe and attach it t
each
project, then you should be able to elect to always trust conten
from the
certificate provider, and the warning should stop appearing for th
books in
question.

Robin Hammond
www.enhanceddatasystems.com

*****
original post clipped
*****
*

Thanks for the suggestions. I agree that lowering the security leve
is not wise. I tried the Digital Signature approach and it does no
work. It adds some overhead -- the base application now tries t
connect to the web at startup; probably trying to verify the digita
signature. The "enable macros" prompts for the target spreadsheet
still appear. These spreadsheets were not created by me. Also, th
macros are apparently Excel4 macros if that makes any difference.

I tried adding Application.DisplayAlerts = False. That strangel
disabled the macros in the target spreadsheets, but a different warnin
message appeared (which is just as annoying).

It would seem reasonable that there exists some way to programmaticall
disable any macro as the file is opened

--
Message posted from http://www.ExcelForum.com