View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ken Warthen[_2_] Ken Warthen[_2_] is offline
external usenet poster
 
Posts: 70
Default Permissions to a macro

Neil,

You could create a login userform and then use the username to determine
whether to enable or disable the command button. You could probably do the
same just using Windows username properties. I guess it depends on how large
your user base might be. I've used the login form method on several projects.

Ken

"Neil Holden" wrote:

I have a button in excel, i want only certain users to be able to press it,
is they any way i can add permissions to the button?

Neil.