Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Repost - CommandBarButtons not responding
Several days ago, I posted a couple of messages about this subject, and have
not gotten any responses that help resolve the issue, so let me repost. I have an Excel application that is using a Userform to capture data and put it into a hidden spreadsheet (this works great). As part of that app, I have a couple of popup menus that are raised when a user clicks on a label on my form. Up until about 3 days ago, one of the command bars was working properly, but then started to act up in two ways. 1. I have a CommandBarButton that when I change the state between msoButtonDown and msoButtonUp, should show/hide a checkmark in front of the button. As I indicated before, this was working, but no longer is (although) the state value does change properly and can be checked via code. 2. I have two other buttons that I am trying to either enable/disable based on which tab of a multipage tab control is visible. But the commands to enable/disable the control are not having an effect on either the display or the function of these buttons. If they are enabled, and I disable them, they remain enabled and continue to function when clicked. I have added some error handling to the routines that find and manipulate these command bar controls, but the errors never fire. The code properly finds the control and appears to set the properties, but has not effect on the actual commandbar. This is an application that will be forwarded to about 20 different organizations, and I would really like it to work properly. I've thought about using the label control to delete and then recreate these controls from the command bar, but hate to keep modifying the commandbar after the forms instantiation. In Access, I'd just create a blank (clean) database and copy everything from one database to the other, at least as a first step, but am not familiar with an easy way to accomplish this within Excel. Your help, recommendations, or suggestions would be greatly appreciated. I am spending way too much time trying to figure out why this stopped working. -- Don''t forget to rate the post if it was helpful! Email address is not valid. Please reply to newsgroup only. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Repost - CommandBarButtons not responding
I have seen this code cleaner recommended:
http://www.appspro.com/Utilities/CodeCleaner.htm "Dale Fye" wrote: Several days ago, I posted a couple of messages about this subject, and have not gotten any responses that help resolve the issue, so let me repost. I have an Excel application that is using a Userform to capture data and put it into a hidden spreadsheet (this works great). As part of that app, I have a couple of popup menus that are raised when a user clicks on a label on my form. Up until about 3 days ago, one of the command bars was working properly, but then started to act up in two ways. 1. I have a CommandBarButton that when I change the state between msoButtonDown and msoButtonUp, should show/hide a checkmark in front of the button. As I indicated before, this was working, but no longer is (although) the state value does change properly and can be checked via code. 2. I have two other buttons that I am trying to either enable/disable based on which tab of a multipage tab control is visible. But the commands to enable/disable the control are not having an effect on either the display or the function of these buttons. If they are enabled, and I disable them, they remain enabled and continue to function when clicked. I have added some error handling to the routines that find and manipulate these command bar controls, but the errors never fire. The code properly finds the control and appears to set the properties, but has not effect on the actual commandbar. This is an application that will be forwarded to about 20 different organizations, and I would really like it to work properly. I've thought about using the label control to delete and then recreate these controls from the command bar, but hate to keep modifying the commandbar after the forms instantiation. In Access, I'd just create a blank (clean) database and copy everything from one database to the other, at least as a first step, but am not familiar with an easy way to accomplish this within Excel. Your help, recommendations, or suggestions would be greatly appreciated. I am spending way too much time trying to figure out why this stopped working. -- Don''t forget to rate the post if it was helpful! Email address is not valid. Please reply to newsgroup only. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Repost - CommandBarButtons not responding
Thanks, I forgot to mention that I had already done that as well.
Frustrated ;-( -- Email address is not valid. Please reply to newsgroup only. "Gleam" wrote: I have seen this code cleaner recommended: http://www.appspro.com/Utilities/CodeCleaner.htm "Dale Fye" wrote: Several days ago, I posted a couple of messages about this subject, and have not gotten any responses that help resolve the issue, so let me repost. I have an Excel application that is using a Userform to capture data and put it into a hidden spreadsheet (this works great). As part of that app, I have a couple of popup menus that are raised when a user clicks on a label on my form. Up until about 3 days ago, one of the command bars was working properly, but then started to act up in two ways. 1. I have a CommandBarButton that when I change the state between msoButtonDown and msoButtonUp, should show/hide a checkmark in front of the button. As I indicated before, this was working, but no longer is (although) the state value does change properly and can be checked via code. 2. I have two other buttons that I am trying to either enable/disable based on which tab of a multipage tab control is visible. But the commands to enable/disable the control are not having an effect on either the display or the function of these buttons. If they are enabled, and I disable them, they remain enabled and continue to function when clicked. I have added some error handling to the routines that find and manipulate these command bar controls, but the errors never fire. The code properly finds the control and appears to set the properties, but has not effect on the actual commandbar. This is an application that will be forwarded to about 20 different organizations, and I would really like it to work properly. I've thought about using the label control to delete and then recreate these controls from the command bar, but hate to keep modifying the commandbar after the forms instantiation. In Access, I'd just create a blank (clean) database and copy everything from one database to the other, at least as a first step, but am not familiar with an easy way to accomplish this within Excel. Your help, recommendations, or suggestions would be greatly appreciated. I am spending way too much time trying to figure out why this stopped working. -- Don''t forget to rate the post if it was helpful! Email address is not valid. Please reply to newsgroup only. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not responding...... | Excel Worksheet Functions | |||
why does it say not responding | New Users to Excel | |||
Excel not responding | Excel Discussion (Misc queries) | |||
CommandBarButtons not responding | Excel Programming | |||
VBA module not responding!?? | Excel Programming |