Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Using Xl97 on NT. I created two command buttons and then set TakeFocusOnClick to False since it was giving me some problems in 97. This bug is described in an article in the knowledgebase (# 177527 ) http://support.microsoft.com/defaul...7&Product=xlw97 But... when now I want to change another property of the buttons (remove accelerator letter), i get another issue. In the design mode the rightclicking of the button is not working because of the above I believe. Is there a way to access properties via VBA? Thanks much, Greg |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
the above problem does not affect viewing properties. If you have trouble
viewing them (and I have run into this), go into design mode. Click on the control, then click the properties button in the control toolbox toolbar. -- Regards, Tom Ogilvy "greg" wrote in message ... Hi, Using Xl97 on NT. I created two command buttons and then set TakeFocusOnClick to False since it was giving me some problems in 97. This bug is described in an article in the knowledgebase (# 177527 ) http://support.microsoft.com/defaul...7&Product=xlw97 But... when now I want to change another property of the buttons (remove accelerator letter), i get another issue. In the design mode the rightclicking of the button is not working because of the above I believe. Is there a way to access properties via VBA? Thanks much, Greg |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks so much, Tom, you are great help
-----Original Message----- the above problem does not affect viewing properties. If you have trouble viewing them (and I have run into this), go into design mode. Click on the control, then click the properties button in the control toolbox toolbar. -- Regards, Tom Ogilvy "greg" wrote in message ... Hi, Using Xl97 on NT. I created two command buttons and then set TakeFocusOnClick to False since it was giving me some problems in 97. This bug is described in an article in the knowledgebase (# 177527 ) http://support.microsoft.com/defaul...7&Product=xlw97 But... when now I want to change another property of the buttons (remove accelerator letter), i get another issue. In the design mode the rightclicking of the button is not working because of the above I believe. Is there a way to access properties via VBA? Thanks much, Greg . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Command Button Properties | Excel Discussion (Misc queries) | |||
command button properties | Excel Worksheet Functions | |||
Change active cell properties with command button | Excel Programming | |||
Change active cell properties with command button | Excel Programming | |||
Command Button Properties | Excel Programming |