Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Command Button
I have inserted two buttons CMD1 and CMD 2. On opening the workbook, I should
have the cmd 1 enabled and cmd2 disabled. How to do it? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Command Button
Raj 2 ways Right click on button select properties Select Enable and change to flase From within a macro Private Sub CommandButton1_Click() CommandButton2.Enabled = False Your Code Here End Sub -- mudraker ------------------------------------------------------------------------ mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473 View this thread: http://www.excelforum.com/showthread...hreadid=520920 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to disable/enable command button(ActiveX) using macro | Excel Discussion (Misc queries) | |||
How disable menu command | Excel Discussion (Misc queries) | |||
Disable command button | Excel Programming | |||
Disable Command Button when File name begins with Customer? | Excel Programming | |||
How I disable a command button until cell has value? | Excel Programming |