View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Coza Coza is offline
external usenet poster
 
Posts: 38
Default Userform enable/disable

Try using the :
Userform.Hide and
Userfrom.Show instead

The user cannot alter the Userform if it is NOT displayed.

Corey....
"Ozgur Pars" wrote in message
...
Hi there,
I have a userform which I "disable" after a submission with
Userform1.enabled=false. And after some calculations in another sub I have
Userform1.enabled=true. However the form is not enabled. Why?

I would appreciate if anybody could help me around this problem.

Thanks,
Ozgur