Hi everyone. Looking for a way to prevent a sheet from someone acidently deleting it without protecting the workbook because there are other sheet that I want to allow them to delete if needed. Any thoughts on this one?
Hi everyone. Looking for a way to prevent a sheet from someone acidently deleting it without protecting the workbook because there are other sheet that I want to allow them to delete if needed. Any thoughts on this one?
I'd prevent deleting all sheets (protect workbook) and add a macro with which you allow the user to delete a sheet. That way you're in control.
Hide the critical worksheet. (or very hide it)