allow users to edit a range in excel 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a spreadsheet for users using Excel 2000 and I would like to
protect the worksheet and still allow users to edit a range of cells in the
worksheet. By just applying a password to the worksheet I would have to rely
on the other users remembering to put the password back on again once they
had finished entering their data. I know that this facility is available in
later versions of Excel and I was wondering if there was a way to replicate
it in Excel 2000.
 
Here's what I normally do:

By default all cells are Locked. I usually Unlock all cells and only Lock
the ones that I do not want people getting in to. After that, when you
password protect the sheet, the section that reads "Allow all user of this
worksheet to", I uncheck Select locked cells.


HTH
 
Thanks for the reply, however, I only want the users to be able to enter data
in their own paticular range in the woksheet and to prevent them fom editing
the data in eachothers range.
 
My bad, I was thinking they could all key in specific ranges.

Hmmm, how many users are we talking about?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I protect a worksheet yet allow editing in Excel 2000 1
Allow Insert Rows in a protected worksheet 2
Allow Users to Edit Ranges??? 8
Macro to Protect the Whole Workbook and Allow Range Edits 2
Excel 2000: allow users to edit ranges 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Edit text format in non-protected cells in protected worksheet 1
allow users to edit ranges 2

Back
Top