Macro security prompt wont go away

M

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
 
K

Kassie

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

--
HTH

Kassie

Replace xxx with hotmail
 
F

Fluke

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

Shaun
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top