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? |
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 |
All times are GMT +1. The time now is 11:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com