PC Review


Reply
Thread Tools Rate Thread

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

 
 
William DeLeo
Guest
Posts: n/a
 
      14th 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...fo&userid=1256
View this thread: http://www.excelforum.com/showthread...hreadid=551911

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Use dd menu choice to filter input for next ddm, etc. William DeLeo Microsoft Excel Misc 6 12th Jun 2006 09:59 PM
Sony DDM-P234 question ebow Video Cards 2 26th Feb 2005 04:59 AM
DDM (Dividend Discount Model) Slow386 Microsoft Excel Misc 1 28th Nov 2004 01:57 PM
Re: DDM You are Awsom Harald Staff Microsoft Excel Misc 4 8th May 2004 12:32 AM
Re: DDM You are Awsom DDM Microsoft Excel Misc 0 6th May 2004 08:54 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:02 AM.