| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dim and Disable Buttons
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Dim and Disable Buttons
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Dim and Disable Buttons
"FSt1" wrote: 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!! 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 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enable / Disable Buttons | Excel Programming | |||
| enable/disable multiple buttons | Excel Discussion (Misc queries) | |||
| Disable some buttons in ShowDataForm | Excel Programming | |||
| Disable Focus on Command Buttons | Excel Programming | |||
| Disable Min Max restore buttons | Excel Programming | |||
Linear Mode
