Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 170
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Making a drop down list read info from another tab / worksheet Paul New Users to Excel 4 September 5th 08 07:14 AM
How do you save an excel file to be read as IBM-type text file ? Dee Franklin Excel Worksheet Functions 2 October 10th 06 02:46 AM
excel 2002 -how can you convert a file to a pdf read only file? spunkyf15 Excel Discussion (Misc queries) 4 September 29th 06 09:36 PM
Pasword protected Excel file encrypted, how do I read this file? jonesteam Excel Discussion (Misc queries) 2 December 12th 05 06:32 PM
"Unable to read file" error message when opening a Excel file that contains a PivotTable report. Tim Marsden Charts and Charting in Excel 2 October 15th 05 02:10 PM


All times are GMT +1. The time now is 05:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"