View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sue Sue is offline
external usenet poster
 
Posts: 285
Default Enable / Disable Buttons

Hi

On a userform I have 3 commandbuttons - say CB1, CB2,CB3 all send info to
different sheets however I'm slipping up sometimes by clicking on the wrong
button and sending the info to the wrong sheet is it possible by using a
Checkbox to use CB1 and Disable CB2 & CB3 and like wise when necessary Enable
CB2 and Disable CB1 and CB3
--
Many Thanks

Sue