I am running an excel template with 3 tabs through Report Caster via email. When you open the attachment you have to enable editing before the macros populate the cells on the first tab and the graphs on the second. (the third is raw data and I hide it). Is there a way to by pass this so that the user doesn't have to say OK for the attachment to be readable?

It would be more desirable if the information presented itself on loading

Maybe some command or something in post processing?

This message has been edited. Last edited by: FP Mod Chuck,

This is a MS-Excel security feature that has to be changed on each computer.

Your application/network admin can us a GPO to perform the global change if this is something authorized by your organisation.
Otherwise it must be performed individually on each computer (still if authorized).

The way that I removed this requirement (in a previous life!) was to use VBScript on the server to open an MS Excel app, open the file and execute the VBA before saving it minus the VBA code.

Send this to your users and they will not get the prompt.

I wrote an article which is available, along with many others, at http://www.informationbuilders.com/support/developers. Look at the one for Excel Templates.

T