Access control on Button in Excel form

**psatkar** · 11-09-2006, 04:28 AM

Hi,

I have created a new button on one of the forms I have created in Excel. I have attached VBA code to this button.

I would need only certain persons to have access to this button. Other users should not be able to click on this button.

Is there any way how this access control can be handled? either based on some password or some other way?

Thanks in advance,

Warm regards,
--Prasad

**Mallycat** · 11-09-2006, 04:50 AM

You can use the UserName field that is stored in the Tools\Options section. Trouble is it is not really secure as anyone can change their own name, and many people don't update the field anyway.

Here is the proper way

http://blogs.officezealot.com/charle...2/10/3574.aspx

edit:
So it looks like this will give you the user name

Right(environ(38), Len(environ(38)) - 9)

All you need to do is test the username, then hide or display the button based on the user

**psatkar** · 11-09-2006, 04:58 AM

Thanks for your inputs.

Proper way as mentioned by you seems to be little complicated for a VBA novice person like me!!

Can you please elaborate little more the earlier approach suggested by you of using user name from tools-options?

Warm regards,
--Prasad

**Mallycat** · 11-09-2006, 05:01 AM

Sorry, I was just editing my previous post when you posted. Go back and have another look - I found an easier way.

Access control on Button in Excel form

LinkBack

Thread Tools

Display

Access control on Button in Excel form

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions