View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JoePro82 JoePro82 is offline
external usenet poster
 
Posts: 2
Default Save As Macro only if Check Boxes...

I have a command button that I would like to be able to use as a Save
As button. However on my form I have Check Box 12, 13, 14 that all
MUST be checked in order for the Macro to funtion and allow somebody to
Save. I would also really like to have a Comment window pop up
explaining why the command button is not working if they have not
checked off all 3 boxes. Thanks in advance.