Dim and Disable Buttons

[jswalsh33]

I have a worksheet with Buttons that are used to launch different macros. At
certain times I would like to make some buttons inactive.

I would like to be able to Dim and make thise buttons inactive.

I am running Windows XP and Excel OFFXL7.

Suggestions?

Jim Walsh

 

[FSt1]

hi
not hard really. in help look up the enabled property.
might work like this...
sheets("sheet1").commandbuttton1.endable = false ' to turn off
sheets("sheet1").commandbuttton1.endable = true ' to turn on

but....

At certain times I would like to make some buttons inactive.

this sounds like the real tricky part. due to lack of info, i don't think i
am able to help much further. sorry.

Regards
FSt1

 

[FSt1]

sorry. i misspelled enabled on the example i gave. should be..

sheets("sheet1").commandbuttton1.enabled= false ' to turn off
sheets("sheet1").commandbuttton1.enabled = true ' to turn on

accursed fat fingers!!

regards
FSt1

 

[jswalsh33]

sorry. i misspelled enabled on the example i gave. should be..

accursed fat fingers!!

I tried the suggested code and got runtime error "Object doesn't support
this property or method"

I also do not know what my Button numbers are. Is there a way to tell?

Any additional help would be greatly appreciated.

Jim Walsh