Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command boxes not appearing
Hi,
I have a excel sheet with 4 command boxes. I could view these buttons on some machines on the network but could not view on other machines. I tried with excel 2002 and 2003. I reinstalled and installed Office package. Still I am having the same problem. Could you please advice how to solve this problem. Advanced thanks -CHinna. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command boxes not appearing
Sometimes setting the zoom to 100% will help.
Or if that doesn't help, you may want to consider replacing the command buttons with buttons from the Forms toolbar (and moving/modifying the code behind those original buttons). Vandy wrote: Hi, I have a excel sheet with 4 command boxes. I could view these buttons on some machines on the network but could not view on other machines. I tried with excel 2002 and 2003. I reinstalled and installed Office package. Still I am having the same problem. Could you please advice how to solve this problem. Advanced thanks -CHinna. -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command boxes not appearing
Dave. Thanks for the reply. I tried the first one. It doesn't work. I
tried the 2nd one but I could not edit in design mode as all the tool bar icons are in disabled mode. Is there any other ways I can get it? Dave Peterson wrote: Sometimes setting the zoom to 100% will help. Or if that doesn't help, you may want to consider replacing the command buttons with buttons from the Forms toolbar (and moving/modifying the code behind those original buttons). Vandy wrote: Hi, I have a excel sheet with 4 command boxes. I could view these buttons on some machines on the network but could not view on other machines. I tried with excel 2002 and 2003. I reinstalled and installed Office package. Still I am having the same problem. Could you please advice how to solve this problem. Advanced thanks -CHinna. -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command boxes not appearing
Show the control toolbox toolbar.
Click on the Design mode icon. You'll be able to delete the commandbuttons. Then click on the design mode icon to go back to normal. But you'll still have to move and modify the code that was behind the worksheet for those buttons. Vandy wrote: Dave. Thanks for the reply. I tried the first one. It doesn't work. I tried the 2nd one but I could not edit in design mode as all the tool bar icons are in disabled mode. Is there any other ways I can get it? Dave Peterson wrote: Sometimes setting the zoom to 100% will help. Or if that doesn't help, you may want to consider replacing the command buttons with buttons from the Forms toolbar (and moving/modifying the code behind those original buttons). Vandy wrote: Hi, I have a excel sheet with 4 command boxes. I could view these buttons on some machines on the network but could not view on other machines. I tried with excel 2002 and 2003. I reinstalled and installed Office package. Still I am having the same problem. Could you please advice how to solve this problem. Advanced thanks -CHinna. -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command boxes not appearing
Dave,
I tried the way you told, But I could not edit the icons as still they are in disabled mode. Thanks Dave Peterson wrote: Show the control toolbox toolbar. Click on the Design mode icon. You'll be able to delete the commandbuttons. Then click on the design mode icon to go back to normal. But you'll still have to move and modify the code that was behind the worksheet for those buttons. Vandy wrote: Dave. Thanks for the reply. I tried the first one. It doesn't work. I tried the 2nd one but I could not edit in design mode as all the tool bar icons are in disabled mode. Is there any other ways I can get it? Dave Peterson wrote: Sometimes setting the zoom to 100% will help. Or if that doesn't help, you may want to consider replacing the command buttons with buttons from the Forms toolbar (and moving/modifying the code behind those original buttons). Vandy wrote: Hi, I have a excel sheet with 4 command boxes. I could view these buttons on some machines on the network but could not view on other machines. I tried with excel 2002 and 2003. I reinstalled and installed Office package. Still I am having the same problem. Could you please advice how to solve this problem. Advanced thanks -CHinna. -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command boxes not appearing
If you go into design mode and rightclick on the commandbutton and choose Cut,
does the button disappear? I don't have any other suggestions. Vandy wrote: Dave, I tried the way you told, But I could not edit the icons as still they are in disabled mode. Thanks Dave Peterson wrote: Show the control toolbox toolbar. Click on the Design mode icon. You'll be able to delete the commandbuttons. Then click on the design mode icon to go back to normal. But you'll still have to move and modify the code that was behind the worksheet for those buttons. Vandy wrote: Dave. Thanks for the reply. I tried the first one. It doesn't work. I tried the 2nd one but I could not edit in design mode as all the tool bar icons are in disabled mode. Is there any other ways I can get it? Dave Peterson wrote: Sometimes setting the zoom to 100% will help. Or if that doesn't help, you may want to consider replacing the command buttons with buttons from the Forms toolbar (and moving/modifying the code behind those original buttons). Vandy wrote: Hi, I have a excel sheet with 4 command boxes. I could view these buttons on some machines on the network but could not view on other machines. I tried with excel 2002 and 2003. I reinstalled and installed Office package. Still I am having the same problem. Could you please advice how to solve this problem. Advanced thanks -CHinna. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command boxes not appearing
And make sure the worksheet is unprotected, too.
Dave Peterson wrote: If you go into design mode and rightclick on the commandbutton and choose Cut, does the button disappear? I don't have any other suggestions. Vandy wrote: Dave, I tried the way you told, But I could not edit the icons as still they are in disabled mode. Thanks Dave Peterson wrote: Show the control toolbox toolbar. Click on the Design mode icon. You'll be able to delete the commandbuttons. Then click on the design mode icon to go back to normal. But you'll still have to move and modify the code that was behind the worksheet for those buttons. Vandy wrote: Dave. Thanks for the reply. I tried the first one. It doesn't work. I tried the 2nd one but I could not edit in design mode as all the tool bar icons are in disabled mode. Is there any other ways I can get it? Dave Peterson wrote: Sometimes setting the zoom to 100% will help. Or if that doesn't help, you may want to consider replacing the command buttons with buttons from the Forms toolbar (and moving/modifying the code behind those original buttons). Vandy wrote: Hi, I have a excel sheet with 4 command boxes. I could view these buttons on some machines on the network but could not view on other machines. I tried with excel 2002 and 2003. I reinstalled and installed Office package. Still I am having the same problem. Could you please advice how to solve this problem. Advanced thanks -CHinna. -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
# sign appearing in text boxes, Why? | Excel Discussion (Misc queries) | |||
Data validation boxes, outputting a final number from the boxes | Excel Discussion (Misc queries) | |||
Formatting calculated number appearing in the text in message boxes | Excel Programming | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
Entering data into two text boxes using one command button | Excel Programming |