Locking cells

[halcyoneus]

Well, I want to do more then just lock cells....

I have a little program whipped up in ecxel and I don't want anyone to be able to modify any cells except cells A1 or A2. I've been able to do this using the Validation function in Excel, but want to go 1 step further. I don't even want anyone to be able to select any other cells. If they do, I want the selection to automatically select either A1 or A2.

Anyone have any ideas to help?

~Hal

 

[RAM]

Hal,

Hold down Ctrl and select the two cells you want the user to be able to select. Format - Cells and unselect Locked in the protection tab - OK. Then Tools - Protection and select Protect Sheet. Unselect Select locked cells,
(make sure only Select unlocked cells is maked) - OK.

Edit: The second post in this topic also tells you how to dock the protection toolbar in the menu. It will speed things up when you're working with protections.

HTH

RAM

 

[halcyoneus]

That is a better way of protecting the sheet then I was doing....but is there any way to not allow any other cell to even be selected?

~Hal

 

[RAM]

Hal,

Your way of protecting is good too. It protects the sheet from incorrect values. Good job on that one.

....but is there any way to not allow any other cell to even be selected?

Yes, just follow my instructions above. I use that all the time.

Tools - Protection and select Protect Sheet. Unselect Select locked cells,
(make sure that only Select unlocked cells is marked)

HTH

RAM

 

[halcyoneus]

quote:
--------------------------------------------------------------------------------
Tools - Protection and select Protect Sheet. Unselect Select locked cells,
(make sure only Select unlocked cells is maked)
--------------------------------------------------------------------------------

I don't see that option when I go into Tools, Protection, Protect sheet(Bolded in quote). There are 3 check boxes....Contents, Objects, and Scenarios.

What am I missing?

~Hal

 

[XLGibbs]

Hmmm,

the only place I have seen this is in the VB window, with respect to Sheet properties... "Enable Selection" which has the option to only allow unlocked cells to be selected.

[/img]

 

[RAM]

I don't know. You should have 15 selections. What version of Excel are you using?

Anybody else on this one?

RAM

 

[halcyoneus]

I'm using Office 2000 Premium.

~Hal

 

[XLGibbs]

I think that 15 options choice is only in 2003 forward RAM.

You can right click the sheet and select view code.

In the toolbar select view>properties window

In the object explorer click the sheet that you need to make the change

in the properties window, change the Enable Selection property as needed.

 

[halcyoneus]

Hmmm,

the only place I have seen this is in the VB window, with respect to Sheet properties... "Enable Selection" which has the option to only allow unlocked cells to be selected.

Got it....
Going off your comments here Gibbs, I found the "Enable Selection" in the VB window. I protected the sheet like RAM suggested and changed the "Enable Selection" to 1 - xlUnlockedCells.

Thanks for both of you for your help.

~Hal