Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel course tate modern - Ensuring an Excel spreadsheet cannot be deleted

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel course tate modern - Ensuring an Excel spreadsheet cannot be deleted

Resolved · Low Priority · Version Standard

Reply 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?

For upcoming training course dates see: Pricing & availability

Reply 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

Reply 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?

Reply 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?

Reply 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

Reply 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

Reply Mon 22 Oct 2007, 16:58Trainer Richard said...

RE: Ensuring an Excel spreadsheet cannot be deleted

Great, hope it works out

Excel articles

· How to start using Excel 2007 Functions
· Getting To Grips With Gantt In Excel
· Let Excel look after the pennies, and the pounds will take care of themselves
· How To Use Excel To Create Large SQL Insert Statements
· The Mysteries Of Excel Explained

Excel tip:

Saving your Excel Spreadsheet as a CSV File

In situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps.

Click the File tab and click Save As.
Enter a name in the File name field.
Click the drop-down arrow next to the Save as type field to select the file type. Scroll down the list and select CSV (comma delimited) (*.CSV)
Click Save

The data will now be saved to a separate CSV file which can be used in different applications.

View all Excel hints and tips