View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Soe Soe is offline
external usenet poster
 
Posts: 5
Default make sure macro be loaded without user intervention

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?