Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() I have a series of blocks of code that enable/disable radio buttons and drop down menus. But when I run it, most times (but not ALL times) I get the "object doesn't support this property of method" error pointing to the ".enabled = FALSE" line. I know it soemtimes works as I can see the affect of the disable/enable call. BUT it usually bombs. Any idea from anyone as to why this would fail to execute at times??? Would it fail if it is already set to FALSE and I am trying to set it to FALSE? If so, how would I add a conditional to check first (my attempt at that bombed too, but perhaps for syntax reasons). TIA WD Here are a couple examples of the code: 1. Sheets("Edit Usage").Shapes("Drop Down 31").Select With Selection .Enabled = True End With 2. Sheets("Edit Usage").Shapes("Drop Down 1").Select With Selection .Enabled = False End With -- William DeLeo ------------------------------------------------------------------------ William DeLeo's Profile: http://www.excelforum.com/member.php...fo&userid=1256 View this thread: http://www.excelforum.com/showthread...hreadid=551911 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
object reference does not support this property or method | Excel Discussion (Misc queries) | |||
Property Let: assign return value of Double when passing String | Excel Discussion (Misc queries) | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
List of property names and values for a given object. | Excel Worksheet Functions | |||
Object doesn't support this property or method (Error 438) | Excel Discussion (Misc queries) |