make sure macro be loaded without user intervention
Soe,
Why not try defaulting the columns to protected and having
the macro UNprotect the columns. That way, if the user
disables the macro, he cannot disable the protection.
Regards,
Ryan
-----Original Message-----
i hv a code which protects selected columns according to
users' login name,
so that unautorized user can't edit on columns on which
he is not supposed
to.
there is a problem, user has to "enable" macro when he
opens the workbook.
If he disable the macro, then the whole protection dies
as there is no macro
to run to check login name and authorization.
anybody can advice?
.
|