You will also need a way for each user to enter the password in Rng E2 ?? on
Workbook_Open so that it is not hard coded.

Likewise the Workbook_Before_Close event needs to empty E2 for the same
reason.

"CLR" wrote:

Very nice Bob...........EXACTLY what I was looking for..........

Thank you very kindly...........

Vaya con Dios,
Chuck, CABGx3



"Bob Umlas" wrote in message
...
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