98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel course tate modern - Ensuring an Excel spreadsheet cannot be deleted | Excel forum
excel course tate modern - Ensuring an Excel spreadsheet cannot be deleted | Excel forum
Resolved · Low Priority · Version Standard
Jacky has attended:
Excel VBA Intro Intermediate course
Ensuring an Excel spreadsheet cannot be deleted
I have a worksheet that has data input from others, so I have protected it so that they cannot delete data from the cells they don't input into, but I need to be able to ensure that they cannot delete the whole file in error. I cannot make it read-only because I want them to be able to enter their data into it...is there any way around this?
RE: Ensuring an Excel spreadsheet cannot be deleted
Try TOOLS >PROTECTION > PROTECT WORKBOOK
This will lock the workbook, and stop users deleting the sheets
RE: Ensuring an Excel spreadsheet cannot be deleted
Hi Richard
This will lock the workbook and stop users deleting the sheets, but it won't stop them deleting the workbook completely
Any other ideas?
RE: Ensuring an Excel spreadsheet cannot be deleted
Hi Richard
This will lock the workbook and stop users deleting the sheets, but it won't stop them deleting the workbook completely
Any other ideas?
RE: Ensuring an Excel spreadsheet cannot be deleted
When you say "deleting the workbook completely", are you referring to the EXCEL FILE in windows?
If so, depending on your network and server system in the office, you may be able to set the permissions of the folder the file is in to EDIT, but not DELETE OR ADD.
Speak to your System admin if you have one.
Richard
RE: Ensuring an Excel spreadsheet cannot be deleted
Hi
Yes that is what I am referring to, so thanks.
Kind regards
Jacky
RE: Ensuring an Excel spreadsheet cannot be deleted
Great, hope it works out
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Trace Dependents / Precedents without the blue arrowsRather than using the toolbar you can press CTRL+] which is the equivelent of trace dependants and CTRL+[ for precendants. Both of these ways though will not show the blue arrows but jump to the cell containing the formula. |