Accessing Active X command button properties
 

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

Accessing Active X command button properties
 

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

Accessing Active X command button properties
 

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


.