PDA

View Full Version : pervent only one sheet from deletion



wilg
02-06-2011, 06:35 PM
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?

Jan Karel Pieterse
02-07-2011, 03:43 AM
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.

mikerickson
02-07-2011, 07:40 AM
Hide the critical worksheet. (or very hide it)