Protecting worksheets

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

Resolved · High Priority · Version 2003

Kimberly has attended:
Excel Intermediate course

by - delegate Kimberly [1 post] (2008 May 20 Tue, 16:04) Reply

Is it possible to protect a worksheet so that it can only be deleted and copied by first entering a password?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 29 Fri	Southwark	3	book now	£224	£235
2003	2008 Sep 3 Wed	Bloomsbury	4	book now	£224	£235
2003	2008 Sep 5 Fri	Bayswater	4	book now	£195	£205
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	7	book now	£203	£230
Full Schedule: See all 127 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Protecting worksheets

by - trainer Stephen gold contributer [326 posts] (2008 May 21 Wed, 10:54) Reply

Hi Kimberly

Thank you for your question

There is no mechanism in Excel whereby you can password protect a file from copying or deleting

However, depending on the version of windows that you are using together with the nature of your network it might be possible to apply such protetction via the user group route.

This is however highly technical and there are too many variables for us to describe a precise procedure here. I suggest that you raise the issue with the person who manages your network, as they will have the exact knowledge of your system and will be able to advise on what is possible.

Regards

Stephen

· Features of Microsoft Excel that assist in Analysis of Financial Data
· Reasons Why VBA for Excel Training Fails
· What's Better Than the Help Function in Excel? Microsoft Training
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· How Excel Training Can Improve Your Company's Sales Process

Please browse our web site to find out more about
excel vba courses and other Microsoft training courses.

Excel tip:

Creating custom lists

In Excel if you type in January in a cell, you can then copy this cell to replicate Febraury, MArch, April etc.

This list has come from Tools- options and Custom lists.

Therefore to save time and create your own list you can click on New (in Tools and custom list tab) and type out the lsit that you want copied quickly.

All you have to do is then type in the 1st word and you will be able to copy the rest of the list quickly.

View all Excel hints and tips