| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| OT I would want protect my sheets of excel from a "password recovery" software... How? | Excel Worksheet Functions | |||
| Protect Workbook Vs Protect Sheet | New Users to Excel | |||
| Can I protect columns w/in a "List" using Protect Sheet? | Excel Discussion (Misc queries) | |||
| Protect Workbook | Excel Discussion (Misc queries) | |||
| Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Linear Mode
