98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum 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
Thu 18 Oct 2007, 10:04Delegate Jacky said...
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?
Mon 22 Oct 2007, 16:34Trainer Richard said...
RE: Ensuring an Excel spreadsheet cannot be deleted
Try TOOLS >PROTECTION > PROTECT WORKBOOK
This will lock the workbook, and stop users deleting the sheets
Mon 22 Oct 2007, 16:37Delegate Jacky said...
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?
Mon 22 Oct 2007, 16:37Delegate Jacky said...
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?
Mon 22 Oct 2007, 16:48Trainer Richard said...
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
Mon 22 Oct 2007, 16:52Delegate Jacky said...
RE: Ensuring an Excel spreadsheet cannot be deleted
Hi
Yes that is what I am referring to, so thanks.
Kind regards
Jacky
Mon 22 Oct 2007, 16:58Trainer Richard said...
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. |
