Another Quick easy one?

[Ray2007]

Is it possible to stop a user entering data into a cell without having to protect the cell.

I would like the cell (which has a formula in it) to be visible and auto calculate but i dont want the user to be able to click or select it all.

If i just use "protect" cell using a password , if the user tries to enter data it throws up the error message which says the cell needs unlocking - i dont want this.

Ray

[VBA Noob]

Hi,

One way
Using event code. Place this code in the sheet module e.g right click the sheet name and select view code then paste the below in

Please Login or Register  to view this content.

You can't select or edit B3 now

or with data validation

Data > Validation >Settings tab >Allow >Custom> =A1=""

HTH

VBA Noob