Locking a worksheet / workbook

[Jnegi1030]

I made a spreadsheet for a client, It has lots of formulas and linking between worksheet (65 to be exact). There is only 2 fields in each sheet that I want the client to be able to enter information in which will then calculate things properly based on the formulas ect.

So my questions is there a way to lock all the worksheets except for 2 cells that i want them to be able to enter in a value into?

Thank you!

 

[Mister H]

Hello

By default all cells are protected when you choose to protect the sheet. So what you need to do is select the cells you want someone to be able to key into and right click on that cell and select FormatCells. On the next pop up choose the Protection tab and remove the check mark that says Locked. Now when you protect your sheet (right click sheet tab and select Protect Sheet) the only cells you can enter data in are the ones you just removed the protection from. Hope this makes sense.

Good Luck,
mark

 

[Kenneth Hobson]

Unlock the cells you want and then set sheet protection.

I like to let code modify data without unprotect protect so I do this in ThisWorkbook.

Private Sub Workbook_Open()
  Dim ws As Worksheet
  For Each ws In Worksheets
    ' UserInterfaceOnly:=True allows code to change data.
    ws.Protect "ken", UserInterfaceOnly:=True, DrawingObjects:=True, _
      Contents:=True, Scenarios:=True
  Next ws
End Sub

Don't forget to lock your VBAproject as well.