Macro security prompt wont go away

[mark Stephens]

When I open my macro enabled workbook it has macros disabled...

Is there anyway to get excel 2007 to 'remember' when you tell it to allow
the macros on a workbook, it disables them everytime and I am trying to
automate some processes which is impossible if it wont allow the macros to
run without manual intervention. i am aware of the risks etc but i am a big
boy and capable of deciding if I want a workbook (macro enabled) to be able
to run macros on opening without having to tell it every damn time! Anyone
can help would nost appreciate it.

Regards, Mark Stephens

 

[Kassie]

Digitally sign your macro with Selfcert.exe, and it will work every time

--
HTH

Kassie

Replace xxx with hotmail

 

[Fluke]

Click on TOOLS, MACRO, SECURITY and set it to LOW. Then you shouldn't be
asked at all.

Shaun