Protect sheet help

T

Tsi Waipahu

I have a worksheet was setup to allow users to edit certain ranges when worksheet is protected. I deleted one of the ranges which users should not edit it anymore from the “Allow Users Edit Ranges…†window; however, the deleted range was editable even when the worksheet was protected. Just to experiment, I deleted all ranges from the “Allow Users Edit Ranges…†window, therefore, users should not be able to edit the entire worksheet when the worksheet is protected, and however, I was able to edit all ranges that were pervious setup to allow users to edit. Any ideas?
 
E

Earl Kiosterud

Check that the cells are locked (Format - Cells - Protection).

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Tsi Waipahu said:
I have a worksheet was setup to allow users to edit certain ranges when
Click to expand...
worksheet is protected. I deleted one of the ranges which users should not
edit it anymore from the "Allow Users Edit Ranges." window; however, the
deleted range was editable even when the worksheet was protected. Just to
experiment, I deleted all ranges from the "Allow Users Edit Ranges." window,
therefore, users should not be able to edit the entire worksheet when the
worksheet is protected, and however, I was able to edit all ranges that were
pervious setup to allow users to edit. Any ideas?
 

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
Protected Worksheet Tab Order 1
Allow users to edit ranges problem 2007 0
hide columns on a protected sheet??? 1
Enabling Autofilter and Sorting in a Protected Sheet 2
Deleting Rows form Protected Sheet 1
"find - not working" 1
Allowing Delete Table Rows at a Cells Protected Worksheet 0

Top