Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making a Excel file Read Only
We need to have our shared file to be read only. The problem we have been
having is, if suzy opens the file before we do, we cannot edit the file. So this is what we also need. Suzy cannot open the file before us, or if she does we can still edit the file. Suzy cannot edit the file at all. She must only be able to open it and read only. How can we make this happen? Thank you, Debbie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making a Excel file Read Only
HAve you considered saving the file with password protection? You can
identify a open password and also a modify password. You could give suzy the open password, but not the modify password. You did not specify your Excel version- if 2007 office buttonsave as select file type select the Tools button at bottom of dialog box general options provide suitable passwords. A better solution if available by your IT personnel is assign user permissions to the file. HTH "DebbieSue" wrote: We need to have our shared file to be read only. The problem we have been having is, if suzy opens the file before we do, we cannot edit the file. So this is what we also need. Suzy cannot open the file before us, or if she does we can still edit the file. Suzy cannot edit the file at all. She must only be able to open it and read only. How can we make this happen? Thank you, Debbie |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making a Excel file Read Only
On Wed, 13 Jan 2010 03:43:01 +1000, DebbieSue
wrote: We need to have our shared file to be read only. The problem we have been having is, if suzy opens the file before we do, we cannot edit the file. So this is what we also need. Suzy cannot open the file before us, or if she does we can still edit the file. Suzy cannot edit the file at all. She must only be able to open it and read only. How can we make this happen? Convert to PDF? -- cheers, calvin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making a drop down list read info from another tab / worksheet | New Users to Excel | |||
How do you save an excel file to be read as IBM-type text file ? | Excel Worksheet Functions | |||
excel 2002 -how can you convert a file to a pdf read only file? | Excel Discussion (Misc queries) | |||
Pasword protected Excel file encrypted, how do I read this file? | Excel Discussion (Misc queries) | |||
"Unable to read file" error message when opening a Excel file that contains a PivotTable report. | Charts and Charting in Excel |