Read only file

[baha17]

Hi all,
Is there a code to open a file as read only,but only let the users to
alter one of the worksheet.Is that posibile?
Thank you very much for the help and have a pleasant weekend
Baha

 

[AB]

Read-Only is a workbook level property - so you can't have some sheets
read-only but some not-read-only.
What you can have, however, is you can protect with a pwd the sheets
you don't want the users to amend.

 

[baha17]

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

 

[Gord Dibben]

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

 

[baha17]

My apologies, I did not clearly state what the problem was. There are
4 worksheets, sheet1,sheet2,sheet3 and sheet4. sheet1,sheet2 and
sheet4 range(A1:A250") users entering data, sheet3 is the another data
exported from other file. What I want is to let the all users enter
the data on those range but not to able to save them. On the other
hand, sheet3 is to be able to altered. That's all i want. Anyway I
wrote a code for that now, which includes sheet protection and unlock
ranges. It works well indeed. However, just want to know do I really
write that completed code or there is another easy way. Because I
might require similar solution in future.
Thanks
Baha