Pam Coleman Wrote:
Is there a way that when a user opens an excel workbook that it will
enable
the macro without asking to disable or enable? I have users that click
on
disable, then the macro will not run. I have two macro buttons set up
and
they choose the one that is needed at this time. I would rather it
open
and the enable already be set without them having to click on it. Is
this
possible?

Hi Pam

You need to go to Tools Macro Security and set the level to Low


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=478328