Consulting

Results 1 to 3 of 3

Thread: pervent only one sheet from deletion

  1. #1
    VBAX Tutor
    Joined
    Jul 2010
    Posts
    225
    Location

    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?

  2. #2
    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.
    Regards,

    Jan Karel Pieterse
    Excel MVP jkp-ads.com

  3. #3
    Mac Moderator VBAX Guru mikerickson's Avatar
    Joined
    May 2007
    Location
    Davis CA
    Posts
    2,778
    Hide the critical worksheet. (or very hide it)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •