gwtechie72
Please don't multi post.
Posters trying to help you, might spend a considerable amount of time coming
up with a solution to your problem, when it has already been solved at
another location.

Regards
Michael M

"OssieMac" wrote:

To enable macros to run you need to alter the security level. To do this
depends on the version of xl that you are using. For more information on
enabling macros open Help and enter 'macros' in the search field then:

In xl 2007: Select Enable or disable macros in office documents.

In earlier versions: Select Change the security level ......

When setting the security for xl2007 select disable all macros with
notification

In earlier versions select medium.

Regards,

OssieMac

"gwtechie72" wrote:

Is there a way to run a VB Macro with out using the security level. If I have
to disable the security how do I do that?