| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
In article <(E-Mail Removed)>, gazza67 <(E-Mail Removed)> wrote:
>On Sep 9, 1:13 am, gazza67 <garys...@gmail.com> wrote: >> Hi, >> >> I am sure the answer to this must be simple but I just cant find it. I >> have a worksheet that I want to protect (ie prevent all changes to), >> so I go tools - protection - protect sheet. Strangely however, I can >> still make changes to the sheet. Same if I say protect workbook. >> >> Is there some override flag that I dont know about? >> >> Gary > >OK I found the answer myself, you must make sure they are locked >before you do the protecting. Note also, that the protection you get with an xl file is weak at best. It stops people of good will only  |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to protect desired area of workbook and protect code. | avveerkar | Microsoft Excel Discussion | 4 | 13th Jan 2006 02:44 AM |
| Passwords Disappear in OpenOffice (Protect Worksheet, and Protect Workbook) | msnews.microsoft.com | Microsoft Excel Discussion | 6 | 27th Dec 2005 08:14 AM |
| Can protect worksheet then workbook but not Protect and Share in code | ctmom@comcast.net | Microsoft Excel Programming | 5 | 9th Aug 2005 03:26 PM |
| Running a macro to protect a workbook on a already protected workbook UNprotects the workbook ?? | WimR | Microsoft Excel Programming | 9 | 25th Jul 2005 12:44 PM |
| Can't password protect workbook -- no pw protect box on Tools>Opts | =?Utf-8?B?TVM=?= | Microsoft Excel Discussion | 2 | 16th Jul 2005 03:04 PM |
