Your descriptions seem to be at odds.

First post you wanted users to alter one sheet but not others.

Second post you want users to enter data but not to be able to save that data.

Read-only takes care of second scenario.

A mix of the two would most likely require VBA and reliance upon Excel's leaky
security.


Gord Dibben MS Excel MVP


On Fri, 15 Apr 2011 05:19:16 -0700 (PDT), "
wrote:

Thank you for the answer.Actually I do not want to protect the other
sheets,cause users check some data by entering data.so that i have to
allow them to key in data.what i do not want them to leave the data
there,thats why it is read only.i was hoping some magic actually....
Have a good day