View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
michaelberrier
 
Posts: n/a
Default Password restricted single macro and button

Is there a way to attach a password to a single button and/or it's
assigned macro. For example, if you have some utility procedures in a
workbook that only the manger(s) will have access to, can you make a
password window appear when that button is clicked?

Sounds like you could do it with a Userform and/or input box, but I
wonder if there is an easier way?