Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Enable = False without selecting?
Hello all,
Can someone tell me how I can rewrite the following commands so tha the control does not need to be selected to be disabled? Thanks! Sheets("Sheet Name").Shapes("Drop Down 3").Select With Selection .Enabled = False End Wit -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Enable = False without selecting?
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Enable = False without selecting?
Thanks for the quick reply!
Q: That command will DIS-able the control or EN-able it? I need to be able to do both ... Thanks agai -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Enable = False without selecting?
Actually, neither, you have to set it yourself:
Sheets("Sheet Name").Shapes("Drop Down 3").Enabled = False or Sheets("Sheet Name").Shapes("Drop Down 3").Enabled = True -- Regards Juan Pablo González "William DeLeo " wrote in message ... Thanks for the quick reply! Q: That command will DIS-able the control or EN-able it? I need to be able to do both ... Thanks again --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW TO DO ENABLE ENABLE THE QUERY PARAMETER BUTTON? | Excel Worksheet Functions | |||
What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Discussion (Misc queries) | |||
$C$1972,2,FALSE, $C$1972,3,FALSE is ok, But $C$1972,4,FALSE Give # | Excel Worksheet Functions | |||
IF(a1="x",(vlookup 18K rows,2,false),(vlookup 18K,3,false)) RAM? | Excel Worksheet Functions | |||
True Or False, no matter what... it still displays the false statement | Excel Programming |