Macros
 

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

Macros
 

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



.

Macros
 

Fantastic - Just the job.

I noticed it said No virus scanner installed.

But I have - so how do I point excel to it.

Thanks again.

Paul

"Assist" wrote in message
...
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



.