protect worksheet/book
 

I want to allow entries into designated cells and have set up a worksheet
with other cells protected and this all works OK.

How do I allow ONLY "save as" to work and not "save" after cell entries?

Thus the person can view the formula results of their cell entries but not
save the original worksheet/book except by "save as" function.

as always thanks.
--
Gene

protect worksheet/book
 

Locate the file in My Computer/MyDocuments, right click on it and select
Properties. On the General tab, check the Read Only attribute and press OK.

"Gene" wrote:

I want to allow entries into designated cells and have set up a worksheet
with other cells protected and this all works OK.

How do I allow ONLY "save as" to work and not "save" after cell entries?

Thus the person can view the formula results of their cell entries but not
save the original worksheet/book except by "save as" function.

as always thanks.
--
Gene

protect worksheet/book
 

Thank you toni.gee. I could not remember. Again thank you for taking the
time.
--
Gene


"toni.gee" wrote:

Locate the file in My Computer/MyDocuments, right click on it and select
Properties. On the General tab, check the Read Only attribute and press OK.

"Gene" wrote:

I want to allow entries into designated cells and have set up a worksheet
with other cells protected and this all works OK.

How do I allow ONLY "save as" to work and not "save" after cell entries?

Thus the person can view the formula results of their cell entries but not
save the original worksheet/book except by "save as" function.

as always thanks.
--
Gene