How to Prevent Others from Creating and Adding New Sheets in Google Sheets

#googlesheets #googlesheetstutorial #googlecode #googlesheetcode #googlescript
In This video I have shown how to restrict user to add new sheets in google sheets. Most required sheet feature for the public sheet.
We cover programming language topic. We will start from PHP and go on with c#, python, matlab
Subscribe Our Hindi Channel for programming is / @logicwithmj
Subscribe Our English Programming Channel / @logicwithmjenglish
#logicwithmj #logicwithmjenglish #logicwithmj #mjcoder
google sheet code,
google sheet code editor,
google sheet color code,
how to add country code in google sheet,
google sheet qr code,
attendance using qr code and google sheet,
google sheet attendance with qr code,
how to link qr code to google sheet,
scan qr code and save to google sheet,
membuat qr code di google sheet,
ระบบสแกน qr code แล้วให้แสดงข้อมูลจาก google sheet,
google sheets qr code attendance,
google docs code blocks,
how to create qr code for google sheet,
cara membuat qr code di google sheet,
google sheets qr code formula,
scan qr code from android and save it google sheet,
google sheets qr code generator,
google sheet generate qr code,
google page html code,
google sheets qr code inventory,
qr code in google sheet,
google page redeem code kaise banaen,
how to make qr code in google sheet,
google docs qr code,
qr code attendance system google sheet,
google sheet to qr code,
qr code to google sheet,
viết code trên google sheet
function myFunction() {
//Testing
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheets = ss.getSheets();
var sheets_name= "";
for(i in sheets){
var sheetName = sheets[i].getName();
if(sheetName . indexOf("Sheet") GREATER SIGN -1 || sheetName.indexOf("Copy of") GREATER SIGN -1){
sheets_name = sheets_name + " "+ sheetName;
ss.deleteSheet(sheets[i]);
}
}
return sheets_name;
}

[@user-jw4kx4uf9e]

jio manjit bai

[@ruwanleelananda2881]

Good,Good Thanks

[@optionmarathi]

Thanks a lot

[@rmsadistrict794]

big thanks to you

[@rajeshkumarkushwaha8343]

its an amazing idea many many thanks

[@logicwithmj]

thank you boss

[@mrinalchakraborty5548]

apps scripts kaam nahi kar raha hay

[@mskartikdas]

How to hide delet option from spreadsheet. Any one can't delete.

[@dipendra02468]

Shared spreadsheet cannot be deleted. Only admin can delete. Other shared users cannot delete shared spreadsheet.

[@sandeepme29]

Short trick nhi hai koi .?

[@rptirur3511]

Prevent Others from deleting Sheets two or more in Google Sheets?@

[@ABDULLAH-bn4kd]

your email ID?

[@logicwithmj]

[e-mail]