vba excel course london - Protecting a whole document

The UK's most regular instructor-led training courses.
Training information: vba excel course london · Microsoft excel training · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Protecting a whole document

Rebecca has attended:
Excel Advanced course

by - delegate Rebecca [14 posts] (2007 Oct 17 Wed, 11:45) Reply

Can you also tell me how I can protect a workbook so users cannot delete it from the desktop?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	4	book now	£207	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Protecting a whole document

by - trainer Rajeev gold contributer [462 posts] (2007 Oct 21 Sun, 10:37) Reply

Dear Rebecca

See if you can speak to the networking or technical support guy at your workplace.

I know that they can set separate privileges to various groups and users to give various rights and one of them does include deleting files or folders!!

I'll speak to the technical guys here @ Best training and see if they can suggest something!!

Hope this helps!!

· Advanced Excel Training - takes you to the next level
· Training Budgets In A Bad Economy
· Do You Really Need Excel VBA Training?
· Reporting and Analysis with Excel
· Prepare for your MOS Certification with MS Excel Courses

Excel tip:

Quickly copy a formula across sheets

Suppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets.

Remember to ungroup the sheets afterwards! Right-click on any tab and choose Ungroup Sheets to do that.

View all Excel hints and tips