View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] adambush4242@hotmail.com is offline
external usenet poster
 
Posts: 168
Default Command Button Prompt

I have a command button on one of my worksheets and I want to add a
conditional function to it. There are over a hundred cells in my worksheet
that if they all equal zero and you push the button a dialogue box would
appear with the message "Are you sure you want to proceed?" It would have
two options, OK, or cancel, in which the attached macro would only run if the
OK button was pushed. Is this possible? Any help would be greatly
appreciated.

Thanks

Adam Bush