+ Reply to Thread
Results 1 to 9 of 9

Protecting worksheet vs workbook

Hybrid View

  1. #1
    Registered User
    Join Date
    01-15-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    53

    Re: Protecting worksheet vs workbook

    I think we're talking about two different issues (or I'm being very stupid!)

    I already allow users to type into the protected worksheets by having the designated cells as 'unlocked'. I just tried the 'allow users to edit range' option out of interest and couldn't get it to work anyway?

    The issue is that I want to prevent the users from being able to delete one worksheet but not be prevented from deleting the others - protecting the sheet does not affect this and protecting the workbook disables the delete option for all the worksheets. I'm wondering if it has to be some VB code to activate/deactivate the protection dynamically or some such.

  2. #2
    Registered User
    Join Date
    01-15-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    53

    Re: Protecting worksheet vs workbook

    Attached an example.

    The 'do not delete' worksheet - I want it so it is impossible to delete this worksheet but you can still delete the data entry worksheet (or add new ones). Both worksheets are protected, but you can still add data to the data entry sheet.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 01-08-2013, 08:31 PM
  2. Replies: 0
    Last Post: 07-21-2008, 09:18 AM
  3. Protecting a worksheet / workbook with macros
    By WLMPilot in forum Excel General
    Replies: 2
    Last Post: 05-30-2006, 11:40 AM
  4. Replies: 1
    Last Post: 04-18-2006, 01:25 PM
  5. [SOLVED] Disabling Visual Basic Editor After Protecting Worksheet/Workbook
    By Reggie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-26-2006, 09:40 PM

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