If you're command button is on a worksheet, you can use
set the visible property of the button to true/false to
show or hide the button.

With Sheets("SheetNameHere")
.CommandButton1.Visible = False
.CommandButton2.Visible = True
End With

Rohit
-----Original Message-----
Can some please tell me how can I hide a command button
from users which depend on who open the workbook ?

My idea is:
select case Application.UserName
' List of regular user
Case "Moham"
Case "John"
Hide_Cmd_Btn=True
' List of special users
Case "Jad"
Case "Theresa"
Hide_Cmd_Btn=False
end Case
If Hide_Cmd_Btn
VBA code to hide the command btn.
End If
.