+ Reply to Thread
Results 1 to 3 of 3

protecting worksheets from deletion

  1. #1
    Registered User
    Join Date
    01-03-2005
    Posts
    1

    Question protecting worksheets from deletion

    Is there a way to protect worksheet/workbooks from being deleted after the user is in the spreadsheet?

  2. #2
    Registered User
    Join Date
    12-24-2004
    Location
    Sofia, Bulgaria
    MS-Off Ver
    MS Office 2010
    Posts
    31

    Protect workbook

    Tools\Protect\Protect Workbook.
    You may also set a password, and your users will not be able to delete the sheets. Is that you need?

  3. #3
    Forum Contributor
    Join Date
    08-23-2004
    Posts
    210
    You can protect a worksheet or an entire workbook, see here: http://www.rmgsoftware.com/xl/xl048.htm
    so others can not make changes, unless they know the password. To make changes you would need to first unprotect the worksheet. It is possible to protect a worksheet, yet leave individual cells unprotected, so users can input data to those unprotected cells, but not alter the protected area of the worksheet.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1