How to display a prompt message when User has no access to a sheet?

[#1]

Hello everyone,

My project have a Main sheet, where the user can activate the other Sheets by clicking in the images.

I have create a script to give access to the user only in the sheets where it can be accessed.

I would like to displa ya prompt message "You have no access to that sheet", when the user clicks on the button/image of a sheet that has no access.

Someone could help on this?

Thanks

[santiago_respane]

Hi Rodrigo,

maybe this post helps you: Sheet level access

I would hide the sheets and buttons based on section access, this way the user will see only the objects he is allowed to see.

Let me know if it helps.

Kindest regards,

[Mark_Little]

Hi

Could you use something like the suggestion by Sataiago, but on you sheet activation trigger say if(sheet= 1, 'Sheet1', 'errorsheet') errorsheet being another sheet with your normal buttons and you error message. In the users eyes it will look like an error message?

Mark