ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Running VB macros (https://www.excelbanter.com/new-users-excel/165766-running-vbulletin-macros.html)

gwtechie72

Running VB macros
 
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?

OssieMac

Running VB macros
 
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?


Michael M

Running VB macros
 
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?



All times are GMT +1. The time now is 11:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com