at the beginning of each macro:
If Sheets("Whatever").Range("E3").Value<"xyz" then exit sub

pick a sheet & a range & a "password", make the change in the above
statement & you're all set.

Bob Umlas
Excel MVP

"CLR" wrote in message
...
Hi All.............

Is it possible to put a small statement at the beginning of selected
Macros,
that would prevent them from working unless a specific passcode number was
previously typed into a specific cell? I have many Macros set up on
push-buttons but would like to prevent "casual" users and data-entry
people
from using them......but still allow certain macros without this feature
to
be used by everyone.

TIA
Vaya con Dios,
Chuck, CABGx3