Hide command button on worksheet

  • Thread starter Thread starter Mohair
  • Start date Start date
M

Mohair

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
 
There doesn't seem to be a Visible property for command buttons. You can, however, disable it
via the Enabled property.
 
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
 
Back
Top