View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default enable/disable macro

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