View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dave caizley dave caizley is offline
external usenet poster
 
Posts: 19
Default password protect a macro on a command button

Hi

There is a Command Button on my worksheet that I only want selected users to
be able to use.

Is there some simple code I can put at the start of the Macro so that unless
"Yes" is typed in to cell A1, the Macro doesnt activate when the button is
pressed

Many thanks