Can columns be protecteded by an assigned user?

  • Thread starter Thread starter MynithaCherylLinda
  • Start date Start date
M

MynithaCherylLinda

In an attempt to streamline 4 separate worksheets into one, is it possible to
setup 4 columns in one Excel worksheet, then protect each column to allow one
user to edit their assigned column by unlocking and relocking it? Or is
there a better alternative, i.e., linking a main worksheet to each of the
four that will show the edits automatically in my main worksheet?
 
You can use the Allow Users to edit Range feature to set up a worksheet so
that specific areas can be edited by specifc users.

You protect the entire sheet and allow a user to edit a specific range
without a password. Lock all cells, set the Allow areas, protect the sheet
and keep the pasword to yourself. Then the specified users (and only the
specified users) can edit thier areas and nothing else.

In Excel 2007 this feature in in the Changes section of the Review tab.
In earlier versions in is in the Tools:Protection menu
 
Back
Top