ExcelBanter - When I protect it will not allow me to only select the unlocked ce

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - When I protect it will not allow me to only select the unlocked ce (https://www.excelbanter.com/excel-discussion-misc-queries/19554-when-i-protect-will-not-allow-me-only-select-unlocked-ce.html)

Jennifer

When I protect it will not allow me to only select the unlocked ce

Hi,
I am using XP, i have never had this problem before. When I protect the
worksheet and I say that I want to only select the unlocked sells it
automatically puts a check mark in select locked cells. Anyone have any
suggestions as to what is going on. Thank you.
--
Though daily learning, I LOVE EXCEL!
Jennifer

Kassie

Excel defaults to allow users to select both. If you untick Select locked
cells, it works fine

"Jennifer" wrote:

Hi,
I am using XP, i have never had this problem before. When I protect the
worksheet and I say that I want to only select the unlocked sells it
automatically puts a check mark in select locked cells. Anyone have any
suggestions as to what is going on. Thank you.
--
Though daily learning, I LOVE EXCEL!
Jennifer

All times are GMT +1. The time now is 04:34 PM.