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

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

--
HTH

Kassie

Replace xxx with hotmail


"mark Stephens" wrote:

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

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

Shaun

"mark Stephens" wrote:

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