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
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.