View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ryan Poth[_2_] Ryan Poth[_2_] is offline
external usenet poster
 
Posts: 18
Default 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?


.