Dim and Disable Buttons
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
"FSt1" wrote:
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
"jswalsh33" wrote:
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
|