Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22
Default 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



.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Command Button Properties FredL Excel Discussion (Misc queries) 2 February 14th 08 08:20 PM
command button properties gbeard Excel Worksheet Functions 4 April 21st 05 06:02 AM
Change active cell properties with command button Nick Excel Programming 2 January 30th 04 05:11 PM
Change active cell properties with command button Beto[_3_] Excel Programming 0 January 30th 04 04:58 PM
Command Button Properties Darren O'Connell Excel Programming 1 July 17th 03 09:34 AM


All times are GMT +1. The time now is 06:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"