Disable Excel's SELECTION PANE

Hello there Excel gurus!

I tried to search this question over the internet, deeming it is such a simple task, and expecting boatload of links on how to do this. But lo and behold, I can't find any! And now, here I am again.

I was just wondering if there is a way to disable the Excel's SELECTION PANE from view. You see, I made a VBA code that shows multiple buttons, but the visibility of these will depend on the login credential of the user. Cases are:

• USER: General Manager - Visible Buttons: 5
• USER: Sales Manager - Visible Buttons: 3
• USER: Sales Engineer - Visible Buttons: 1

Please Login or Register  to view this content.

I used the visible properties of objects to hide those that are not related to the user. The danger of this is if the user is aware of Selection Pane, he/she can easily override the restriction I set using VBA, and can reveal the other buttons.

I would appreciate your inputs on this guys, or if you have other workaround other than manipulating the Visibility property, I would appreciate it. Thanks in advance!

Thanks a lot @Olly! Exactly what I need!

And thanks to you too, @rorya, for giving me a different but sensible perspective on this case! Care to give an example on how to to do this? The radio buttons are actually within the sheets, and not in a userform.

Makes a lot of sense, @rorya! I assigned a cell in a hidden worksheet and make it as reference for option buttons for identifying a user.

For the benefit of others who might face the similar situation and still looking for answer other than what Olly provided, here's a code that also works referencing @rorya's suggestion:

Please Login or Register  to view this content.

Thanks a lot guys! Highly appreciated!

Useful for me too ! Just keeping for future reference.