ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to stop sheet deletion (https://www.excelbanter.com/excel-programming/321879-how-stop-sheet-deletion.html)

Jeff

How to stop sheet deletion
 
I want to stop people from deleting a specific sheet in a workbook. The
reason for this is that it is a template with scripts and buttons attached to
it. I'm not looking to stop people from changing the sheet, just accidently
removing it.

Bill Kuunders

How to stop sheet deletion
 
Protect the workbook, not the work sheets It will allow changes to the sheet
but will not allow deletions of sheets.
Password is optional
Regards
Bill K

"Jeff" wrote in message
...
I want to stop people from deleting a specific sheet in a workbook. The
reason for this is that it is a template with scripts and buttons attached
to
it. I'm not looking to stop people from changing the sheet, just
accidently
removing it.





All times are GMT +1. The time now is 04:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com