go to
Tools Macro Security and set the security to low.
-----Original Message-----
Hi there is there anyway to prevent the prompt - disable
enable macros every
time you open an excel file with a macro in it.
(Obviously one you have
designed) As third party excel may have virus as per
warning.

I.E. your own workbook defaults to enable and goes
straight in to the
worksheet.

OK I maybe lazy - it just takes one click - but is there
a way ?

Cheers

Paul



.