+ Reply to Thread
Results 1 to 11 of 11

still able to the edit the work sheet which i have protected

  1. #1
    Registered User
    Join Date
    04-07-2020
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    9

    Exclamation still able to the edit the work sheet which i have protected

    m still able to edit the worksheet which i have protected under review tab

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,222

    Re: still able to the edit the work sheet which i have protected

    What steps did you take to turn on protection? What options did you select? What editing are you still able to do? When you are in the review tab, did the Protect Worksheet button change to Unprotect Worksheet?
    Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會
    Please read the rules
    If someone helped you, click on the star icon at the bottom of their post
    If your problem is solved, go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

  3. #3
    Registered User
    Join Date
    04-07-2020
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: still able to the edit the work sheet which i have protected

    Thanks for he responce
    When i protect the entire work sheet in the review tab under protect sheet , when i open that sheet again all the titles like home ,data ,insert ,font etc remains disabled but i am able to type or delete in all the cells of that work sheet which has been protected by me earlier...

  4. #4
    Registered User
    Join Date
    04-07-2020
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: still able to the edit the work sheet which i have protected

    I unchecked the lock box in formate cells under protection tab

  5. #5
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,222

    Re: still able to the edit the work sheet which i have protected

    The cells you want to protect should be Locked like this. There should be a square around the Locked option.

    lockcell.jpg

    If the cell is not locked, the menu looks like this:

    unlockcell.jpg

    Then when you protect the sheet, it should look like this:

    protect.JPG

  6. #6
    Registered User
    Join Date
    04-07-2020
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: still able to the edit the work sheet which i have protected

    It worked
    omg!!!!!
    Thank u very much
    u r wonderful

  7. #7
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,222

    Re: still able to the edit the work sheet which i have protected

    You're welcome and thanks for the rep!

    If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

  8. #8
    Registered User
    Join Date
    04-07-2020
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: still able to the edit the work sheet which i have protected

    thank you very much
    could i except some more help from u
    i will be highly obliged

  9. #9
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,222

    Re: still able to the edit the work sheet which i have protected

    If you have another question please post another thread. Thanks.

  10. #10
    Registered User
    Join Date
    04-07-2020
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    9

    validation of data entered in cell

    in sheet AB AHAD MIR
    I HAVE A CHECK BOK IN 'D' IF I SELECT "BILL.NO" I SHOULD BE ABLE TO ENTER IN THE DAT 'F' ONLY(i.e under bill amount)
    and it should restrict me to enter in 'G' (i.e the received amount)
    and similarly if i select from the check box in 'D' the "payment.no" option it should restrict me to
    enter the data in in F (i.e bill amount).
    HOPE U UNDERSTOOD
    I WILL BE THANK FULL IF U WILL HELP ME OUT
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    04-26-2020
    Location
    Massachusetts
    MS-Off Ver
    Office 365
    Posts
    68

    Re: still able to the edit the work sheet which i have protected

    Go to FILE, INFO, Protect Workbook and set protection there

+ 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. Edit specific objects in protected work sheet
    By L plates in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2020, 04:23 AM
  2. [SOLVED] Edit protected sheet
    By RMontani in forum Excel General
    Replies: 2
    Last Post: 12-07-2017, 03:51 PM
  3. MAcro does not work when certain cells in a work sheet are protected
    By Unnati in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-10-2012, 03:38 AM
  4. Macros stop to work when work sheet is protected. Run time error 1004
    By sellim in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-18-2012, 01:14 AM
  5. Protected Sheet Allow Edit Objects
    By jonhfl in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-11-2011, 10:38 AM
  6. Replies: 2
    Last Post: 07-11-2006, 11:15 PM
  7. [SOLVED] how do you check and edit spelling on a protected sheet.
    By Fredonia in forum Excel General
    Replies: 1
    Last Post: 03-29-2006, 03:35 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