+ Reply to Thread
Results 1 to 3 of 3

How lock for editing

  1. #1
    Registered User
    Join Date
    05-12-2012
    Location
    Austin, TX
    MS-Off Ver
    Excel 2003
    Posts
    17

    How lock for editing

    How can I lock one worksheet in my workbook. I have a summary worksheet with several complicated formulas that I dont want to accidently delete or change. But the rest of the work book needs to remain unlocked.

    Thank you in advance for your help!

  2. #2
    Forum Contributor bonny24tycoon's Avatar
    Join Date
    04-02-2012
    Location
    Hell
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    405

    Re: How lock for editing

    Hi there,

    You can try this.. Help.docx

    The most easiest I could make for you





    Thanks,

    Bonny Tycoon



    **If I was able to help please click the small star icon at the bottom left of my post **

  3. #3
    Forum Contributor bonny24tycoon's Avatar
    Join Date
    04-02-2012
    Location
    Hell
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    405

    Re: How lock for editing

    Hi,

    Just ensure in the 1st screenshot you would need to select all rows and column by clicking on the box between 1 and A.




    Thanks,

    Bonny Tycoon



    **If I was able to help please click the small star icon at the bottom left of my post **

+ 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