enable/disable macro

Is there anyway that the running of macros can be disabled while EXCEL is
OPEN. The only way that I have found to disable macros is to shut down
EXCEL, restart EXCEL, and select to disable the macros.

RICK

You can disable code that run when you open the workbook by holding the
Shift key when you open the workbook in Excel.

Note: You can use the macro's only the code that run automatic when you open the workbook will not run

--
Regards Ron De Bruin
http://www.rondebruin.nl



"RICK" <[email protected]> wrote in message news:[email protected]...
> Is there anyway that the running of macros can be disabled while EXCEL is
> OPEN. The only way that I have found to disable macros is to shut down
> EXCEL, restart EXCEL, and select to disable the macros.
>
> RICK

once disabled can it be re-enabled without closing down and re-opening the
workbook?

You can write all your macros so that they will conditionally operate or not
depending on a certain value in a certain cell.........kinda like a password,
only certain folks know what the password is, and where it is supposed to
go..........

hth
Vaya con Dios,
Chuck, CABGx3



"RICK" wrote:

> Is there anyway that the running of macros can be disabled while EXCEL is
> OPEN. The only way that I have found to disable macros is to shut down
> EXCEL, restart EXCEL, and select to disable the macros.
>
> RICK

I think you have to close and reopen any workbook to enable/disable macros for
that workbook.

RICK wrote:
>
> once disabled can it be re-enabled without closing down and re-opening the
> workbook?

--

Dave Peterson