Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I created a spreadsheet for a friend and I want to protect it so that he
cannot mess up the formula's unless he saves it as a new file (save as). That way he always will have the original to go back to. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Instead of file / save, use file / save as, when creating the file for your
friend. In the dialog that pops up, select Tools / General Options at the top right, and select read-only. You could even choose to require a password to open with write permissions. (You may also want to use Windows Explorer to make the file read-only. Otherwise, Excel will prevent saving over the file, but your friend could still delete the entire thing). "Chrisrmx" wrote: I created a spreadsheet for a friend and I want to protect it so that he cannot mess up the formula's unless he saves it as a new file (save as). That way he always will have the original to go back to. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I access the previous version of a saved file? | Excel Discussion (Misc queries) | |||
Locating saved Excel file | Excel Discussion (Misc queries) | |||
How do I get Excel to open a previously saved file? | Excel Discussion (Misc queries) | |||
Problems using Excel 2000 to open/save file saved in Excel 2003 | Excel Discussion (Misc queries) | |||
Multiple columns of data saved in a CSV file appears in a single c | Excel Discussion (Misc queries) |