View Full Version : pervent only one sheet from deletion
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)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.