HI,
There's no direct and easy way to do so.
You will either have to publish your script as a addon or create a wrapper of script and keep it privately.
Something like web service.
For creating a menu...Do a check if user have rights to access the scripts menu.
It will work this way.
Copy your existing script to new App script project as library.
Attach that library in your spreadsheet.
Verify user and run your main scripts and create menu.
That way your main script will be hidden from users and only be able to run them if you allow any particular user.
Thanks
Hey! Hope so you are good. I have got experties in excel as i have done such kinda task previously as well. I will definitely don't disappoint you in this regard. Have a good day! Thanks.