Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros warning always shows up, even if all macros removed | Excel Discussion (Misc queries) | |||
Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions | |||
Macro Size Limit / open macros with macros? | Excel Programming | |||
Macros not appearing in the Tools Macro Macros list | Excel Programming | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming |