One Click Hyperlink in Google spreadsheets

Question

Is there a way in Google spreadsheets to reach a url with just one click? right Now you need 2 clicks. The first click gives you the option to edit or to goto the link. I want for certain users it goes directly to the link.

=HYPERLINK(A3;"Uren registratie (PZ) ")

Answer 1

At this time, the only solution would be to publish your spreadsheet to a webpage. When you view the links from web-link they are single-clickable.

This Google Help forum about single click links addresses the solution which suggests publishing your GoogleSheet as a webpage. It's not pretty, but it works. The drawback is the spreadsheet isn't editable from that shared link.