Menu
It's well known on how to make a custom upper menu item (https://developers.google.com/apps-script/guides/menus), but can you append a function to the context menu when right clicking a cell or item?
707
You can do this by going to Data > Protected Sheets and Ranges > Sheet > Set Permissions, and in the following window, choose who you want to have editing permissions (optional). Remember that the Editing permission can be given or revoked in the Custom option.
In Google Sheets, select the menu item Extensions > Apps Script to create a script that is bound to the spreadsheet. Delete any code in the script editor and paste in the code below. Return to Sheets and insert an image or drawing by selecting Insert > Image or Insert > Drawing.
Maybe the sheet is protected. Can you access the commands from the Edit menu? If no menu appears with a right-click you shoud try re-setting the r-click.
No. Can't do it. There is no class or method to modify the right click context menu.
138
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
