Hide or Unhide a "Commandbutton" on a worksheet using VBA code

[jmk15315]

I am using a Userform to drive through a workbook. I am using the same worksheet for "Admin" use as well as "User" functions. Is there a way to hide/unhide commandbuttons on the worksheet so they do not appear when the user unhides the worksheet, but do appear when the sheet is accessed by an Admin?

I know how to make this function work within a Userform, but hoping there is a way to perform this in a worksheet.

 

[Akuini]

Is there a way to hide/unhide commandbuttons on the worksheet so they do not appear when the user unhides the worksheet, but do appear when the sheet is accessed by an Admin?

Is it an activex commandbutton?
If you want to refer to the control from a code module, try something like this:

Sheets("Sheet1").CommandButton1.Visible = False

but do appear when the sheet is accessed by an Admin?

How do you determine if the sheet is accessed by an Admin?

 

[jmk15315]

It is not an activex command button. But could be very easily. The sheet is accessed from a userform to make the selection as to which “sheets” to open.
I thought about it being as simple as your suggestion, but I cannot find the identifier for the button name.

 

[Akuini]

but I cannot find the identifier for the button name.

Do you mean the buttons are on multiple sheets & they have different names on each sheets?

 

[jmk15315]

No, the buttons are on one sheet, but it was not an ActiveX button, changing the button to ActiveX instead of using a Form Control button fixed my issue.

Thank You!!!

 

[Akuini]

You're welcome, glad to help & thanks for the feedback.