Results 1 to 3 of 3

Thread: How do I protect a Workbook on Excel 2007?

  1. #1
    Join Date
    Dec 2008
    Posts
    2

    How do I protect a Workbook on Excel 2007?

    Hi,
    I have a workbook with plenty of worksheets with locked and unlocked cells. I want to lock the workbook, but NOT just for the layout or the windows, but for the content. I tried the "Protect Workbook" option, but this doesn´t protect my cells. This option still allows me to change locked cells. Older versions of Excel will also protect locked cells when you protected the workbook. I don´t want to have to enter a password for each worksheet in order to protect the cells. Can I do this, or is this another backward step in the Office 2007 package? Sorry for the frustration!

    Thanks.

  2. #2
    Join Date
    Sep 2005
    Posts
    1,306

    Re: How do I protect a Workbook on Excel 2007?

    Protect worksheet or workbook elements

    When you share a workbook with other users, you may want to protect data in specific worksheet or workbook elements to help prevent it from being changed. You can also specify a password that users must enter to modify specific, protected worksheet and workbook elements. In addition, you can prevent users from changing the structure of a worksheet.

    Protecting worksheet elements
    By default, when you protect a worksheet, all the cells on the worksheet are locked, and users cannot make any changes to a locked cell. For example, they cannot insert, modify, delete, or format data in a locked cell. However, you can specify which elements users will be able to change when you protect the worksheet.

    Check Complete Procedure at This Page

  3. #3
    Join Date
    Jul 2009
    Location
    Kolkata, West Bengal
    Posts
    25

    Re: How do I protect a Workbook on Excel 2007?

    Protect a Worksheet in Excel 2007

    Open an Excel file to protect.

    Click on the Home tab.

    Choose the Format option on the ribbon to open the drop down list.

    Click on Protect Sheet option at the bottom of the list to open the Protect Sheet dialog box.

    This dialog box contains a number of options when protecting the worksheet.

    The first option is to add a password to prevent worksheet protection from being turned off. This password does not stop users from opening the worksheet and viewing the contents.

    Next there a number of options that can be turned on or off with check boxes. The first two allow a user to drag select locked and unlocked cells. If these two are turned off, users will not be able to make any changes to a worksheet - even if it contains unlocked cells.

    The remaining options allow users to carry out specific tasks on a protected worksheet, such as formatting cells and sorting data.

    When you have selected apropriate option click ok.

    Unlocking a protected sheet

    Click on the Home tab.


    Choose the Format option on the ribbon to open the drop down list.


    Click on Unprotect Sheet option at the bottom of the list.

    I hope this helps you.

    THANK YOU

Similar Threads

  1. Replies: 1
    Last Post: 10-04-2012, 11:12 PM
  2. Embedded Excel 2007 workbook gives error in Word 2007.
    By Milo D in forum Windows Software
    Replies: 5
    Last Post: 25-04-2011, 06:56 AM
  3. Workbook is not displaying in Excel 2007
    By Paisley007 in forum Windows Software
    Replies: 3
    Last Post: 29-08-2009, 07:32 PM
  4. Need help in Saving an Excel 2007 Macro-Enabled Workbook
    By Mega mind in forum Windows Software
    Replies: 5
    Last Post: 06-08-2009, 08:43 AM
  5. How can i protect a workbook in Excel 2007
    By stephenx in forum Windows Software
    Replies: 2
    Last Post: 30-04-2009, 06:01 PM

Tags for this Thread

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
  •  
Page generated in 1,711,645,964.57897 seconds with 17 queries