Show/Hide ActiveX Controls

[MarBoTJ]

Hello, can somebody help me? I'm creating a macro file that will be used by around 15 coworkers, but I want only to show certain buttons depending on their role.

For example:
Workers 1,2,4 and 5 will be able to view 4 macro buttons
Workers 3,6,7 and 8 will be able to view 4 diferent macro buttons, not accesible to the previous set of workers.

So far, I found this code to get the username from the person who opens the macro file

Please Login or Register  to view this content.

That's no issue, what I want to do is to put a command that enables/disables viewing certain ActiveX buttons depending on the user that opens the workbook.

[6StringJazzer]

You can manage the visibility of a button like this

Please Login or Register  to view this content.

I can't be any more specific without knowing the actual names of your buttons and roles that the users play. But hopefully this example is what you need.

[Winon]

Hello MarBoTJ,

I think it would be easier to setup a Workbook with Passwords, since anyone could work on another users' PC, and you will be none the wiser.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

I will see how it could be changed as suggested.

Regards.

[MarBoTJ]

Hey, thanks 6StringJazzer, it worked this way:

Please Login or Register  to view this content.

Also thanks Winon, I didn't consider the possibility (remote, but still possible) that other user might use one of the coworkers PC. I'll work on that point and let you know how it ends.

[6StringJazzer]

Glad you got it to work. I would have provided something more specific but I didn't know the code was in the ThisWorkbook module or what the button names were.

Winon has a good point about passwords, although in the final analysis any security mechanism that you would use in Excel is just guidance for people about what they should and shouldn't do. It is difficult (maybe impossible) to make this secure against someone who is deliberately trying to break the security.

[Kyle123]

You're better off not using ActiveX controls on worksheets at all. They're incredibly unstable have a look here https://www.google.co.uk/webhp?sourc...eet%20controls and by using them, you're asking for trouble.

Forms controls are much more reliable - they're in the same dropdown as the ActiveX ones, but are designed for use on worksheets - so you don't run into any stability issues, you can do most of the same things with them too and you can use them without using code.

[6StringJazzer]

I suppose that is a matter of some debate. Some people do indeed have problems with sizing of ActiveX controls in some scenarios. As far as use on worksheets, I would agree you can do most of the same things with them, although if you can do something without code using a Forms control you can do it without code using an ActiveX control. If you do need code, ActiveX features are more powerful and straightforward.

One size does not fit all.

[Kyle123]

What's more straightforward than assigning a macro?

Typically one only needs ActiveX controls if Events are needed - why would you want to use ActiveX controls at all if you aren't using code?