PC Review


Reply
Thread Tools Rate Thread

Conditionally disabling activex toggle buttons

 
 
The Researcher
Guest
Posts: n/a
 
      28th Feb 2010
Does anyone know how I can disable an activex toggle button (I am imagining
it going lightgrey or something like that and the use not being able to use
it) depending on the value of a specific cell?

Any help is greatly appreciated!
 
Reply With Quote
 
 
 
 
JLGWhiz
Guest
Posts: n/a
 
      28th Feb 2010
If it is from the control toolbox and on a worksheet, then:

Sub dk()
Sheets(1).ToggleButton1.Enabled = False
End Sub




"The Researcher" <The (E-Mail Removed)> wrote in message
news:AA8A6070-82B2-44FD-92DD-(E-Mail Removed)...
> Does anyone know how I can disable an activex toggle button (I am
> imagining
> it going lightgrey or something like that and the use not being able to
> use
> it) depending on the value of a specific cell?
>
> Any help is greatly appreciated!



 
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
Toggle Cell Colour Conditionally Ken McLennan Microsoft Excel Worksheet Functions 6 11th Sep 2008 04:55 PM
Conditionally format a label object or a toggle button Jeff @ CI Microsoft Access Form Coding 1 28th Aug 2008 04:48 AM
have toggle buttons but everytime print preview buttons move =?Utf-8?B?VGluU2FuZGh1?= Microsoft Excel Misc 1 11th Oct 2006 02:57 PM
Conditionally disabling formulas nebb Microsoft Excel Programming 0 26th Oct 2004 04:25 PM
Want toolbar w/buttons to toggle javascript and ActiveX controls Fishface Windows XP Internet Explorer 4 9th Mar 2004 11:08 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:02 PM.