ddm enable/disable: Object doesn't support this property, my a** it doesn't

Giganews Newsgroups
Subject: ddm enable/disable: Object doesn't support this property, my a** it doesn't
Posted by:  William DeLeo (William.DeLeo.29efpc_1150300202.172@excelforum-nospam.com)
Date: Wed, 14 Jun 2006

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?action=getinfo&userid=1256
View this thread:http://www.excelforum.com/showthread.php?threadid=551911

Replies