Enable macros

[buckau]

I have an excel 2000 application that I have developed which is now working well it has some macros in it the problem is ever every time I open it, it asks me to Enable macros how can I stop it asking me this and just enable the macros?

 

[ajetrumpet]

change your security to setting to anything but MEDIUM. do this by this process inside excel:

TOOLS > MACRO > SECURITY > choose level you want

 

[buckau]

hi thanks for that but if i set it to High it disables my macro.
how do i mack my macro a sighned macro and mack it a trusted macro?
steve

 

[ajetrumpet]

i have never done it. but use the help menu in excel. type in something like: digital signatures after pressing F1 for help. You have to include yourself as a trusted publisher somehow and then add yourself under TOOLS > OPTIONS > SECURITY