protect worksheet/book

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Excel VBA 1
Protecting Excel Formulas 2
Insert/ delete row in protected worksheet 7
How do I keep a excel worksheets dementions, and the cell size 1
Protect conditional formatting in destination cell 2
How can I merge unprotected cells in a protected worksheet? 1
Hide columns based on row values 2

Back
Top