Prevent multiple cells selection & Lock Cell

[jieyi]

Hi,

I have two questions.

1) Is it possible to prevent the user from selecting multiple cells? I only allow the user to select 1 cell at one time.

2) I have protected some cells which I do not wish the user to edit. Is there a way that I can even prevent the user to select those particular cells?

[Simon Lloyd]

For the protected cells when protecting you a list of options one of which is to allow users to select locked cells, so you need to make sure all other cells are unlocked (Ctrl+A then right click, format, protection, uncheck the locked box, then lock the individual cells you want to protect) as locking cells only works when a sheet is protected.

The select only one cell can be cured like this:

Please Login or Register  to view this content.

put this in the worksheet code module (right click worksheet tab, view code and paste in)