Thread: Macros
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
paul thomas paul thomas is offline
external usenet poster
 
Posts: 7
Default 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