View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default DTPicker Lock property

Change the DTPicker's Enabled value from True to False. Of course, it will look washed out. If you
don't like that look, then store the Value and reassign it in one or more of the DTPicker's events.

HTH,
Bernie
MS Excel MVP


"Ayo" wrote in message
...
Is there a way to lock the DTPicker so that the value can't be changed? I
want to lock the DTPicker to prevent someone from accidentally making a
change to it. I was able to do that for the TextBoxes on the form but the
DTPicker does't have a property like that.
Is there a way to do that?
Thanks