Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there any way to use VBA to disable or "gray-out" a command button in a
worksheet that was created from the Forms toolbar? I tried using worksheets("sheetName").shapes("cmdName").enabled = false but I get an "object doesn't support this property or method" example. I know I can turn the visible property on and off, but I'd rather have it grayed out when it's not available so it's presence is still displayed. Is there a way to accomplish this? Thanks in advance, Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Disabling the minimise button in Excel workbook | Excel Programming | |||
Command Button vs Control Button | Excel Programming | |||
disabling cells based on cmd button | Excel Programming | |||
Disabling font color button | Excel Programming | |||
Command Button vs Form Button | Excel Programming |