| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform enable/disable
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| enable/disable macro | Excel Discussion (Misc queries) | |||
| Enable and Disable Tool Bar | Excel Programming | |||
| Toolbars Disable/Enable | Excel Programming | |||
| Disable/ Enable Macro | Excel Programming | |||
| Enable/Disable Button | Excel Programming | |||
![Ozgur Pars[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
