From the documentation of the the bound script:
<https://developers.google.com/apps-script/guides/bound>

"Only users who have permission to edit a spreadsheet, document, or form can run its bound script. Collaborators who have only view access cannot open the script editor, although if they make a copy of the parent file, they become the owner of the copy and will be able to see and run a copy of the script."

This feature is kinda limited. I have created a big sheet that are used by multiple users. I need the script to be executable by Read Only access users. The script that I created are not making changes to the document, so it should not affect by the access level of the users.

* Administrator have Edit access to the document. They have access to all calculation/ configuration cells/ sheet.
* Managers have Edit access to the document. Managers have Edit access to most of the cells/ sheet. Managers task is to update the cells
* All remaining users only have Read Only access to the document. They can view cells and the automated calculation.

Because the cells have too many columns, I have created a button (eventually I want to move it to onOpen) for easy navigation to a specific cell. This is done dynamically based on today's date.
This is working fine as expected for Administrator and Manager (have Edit access), however not available for the rest of the users with Read Only access.

Is there any workaround for this?

Thanks