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