Can we apply security on button??

[#1]

Can we apply security on button??

[salto]

Hi,

Yes, please have a look at the General -> Enable Condition box in the button properties.

The button will be enabled or not depending on the condition in the box.

If you need to enable / disable depending on the username, you can try using the OsUser() command in the box:

=Osuser('Domain\Username')

Regards.

[#3]

Thanks SALTO ,

But this is not working for me.

=Osuser('Domain\Username')

[salto · Accepted solution]

Sorry,

I did not write the correct syntax.
In the box, you need to write this;

=(osuser()='DOMAIN\username')

You also need to add at least one action to the button, otherwise it will always be disabled!

Regards

[Gysbert_Wassenaar]

Try something like =if(OSUser()='MyDomain\MyUser',1,0). Replace MyDomain\MyUser with the correct domain and user name. If you have more user names that should be considered perhaps you should use section access. Here's an example for sheets, but the same method will work fine for buttons too since they both use the conditional display option of the objects.

[#6]

Dear SALTO,

is it possible??.. when i  click on button it would ask for Username and Password.