Annoying macro security wont remember my settings

M

mark Stephens

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
 
E

Eduardo

Hi,
It has to do with the security level of your computer change it to Mediun
and you will be able to run it
 

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

Similar Threads

Macro security prompt wont go away 2
Need Help with Macro Security 1
Want to have macro execute automatically when doc created 3
Macro security in 2007 5
EXCEL 2007 Macro Security Being Ignored 5
macro security 0
Track changes doesn't remember me 0
saving macro from workbook to Personal Macro Workbook 1

Top