Jimbo,
You can change the security setting for macros in Excel. Go to Tools
Macros Security... and change the setting to Low.
You will have to close Excel and re-open it for the setting take effect.
--
Ken Hudson


"jimbo_jones" wrote:


I have writen a small program that opens a form when a excel file is
opened. I had a problem the other day where the Security was set such
that the macros would not work and the form didn't open.

Is there a way to make certain the the macros will always work so that
my form will always open?

Also excel is always asking if I want to enable macros, is there a
command that will automatically enable macros on opeing an excel file.
This is so that the user doesn't get confused.

Thanks


--
jimbo_jones
------------------------------------------------------------------------
jimbo_jones's Profile: http://www.excelforum.com/member.php...o&userid=27244
View this thread: http://www.excelforum.com/showthread...hreadid=471756