Hi Ohenewa,
The requested functionality cannot be configured for the Spreadsheet component using its API. I've tried to workaround the built-in functionality but I cannot provide a solution that works in all scenarios that I've tested.
I've logged a feature request on your behalf about the currently discussed functionality. Here is the link to the feature request: https://feedback.telerik.com/kendo-jquery-ui/1464763-disable-the-sheets-tabs-reorder-in-spreadsheet. You can vote for the request. The more votes a given request collects, the bigger the chance for its implementation is.
Regards,
Petar
Progress Telerik
Progress is here for your business, like always.
Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.