I need to unprotect sheet so I cn sve it but need a password?
 

I was working on my scouts accounts file which previously I have no problems
with then on completion of some addittions I asked it to be saved.BUT it kept
saying sheet is protected and I cannot alter it.
This is hppening a lot recently and as far as I am aware I have not asked
for protection on any of my workshets in my Microsot progs ie Word or excell

I need to unprotect sheet so I cn sve it but need a password?
 

There are 3 types of protection on an Excel file(4 if you count VBA Project
protection which we can ignore at this point).

1. File to open protection which requires a password to open and/or modify
the file.

2. Workbook structure and windows protection which prevents adding or
deleting worksheets and other stuff.

3. Worksheet protection which prevents making changes to locked cells and
restricts many other functions.

Also.........if workbook is opened "read-only" it cannot be saved after
alterations.

Investigate each of thses to see which is preventing you from progessing.


Gord Dibben MS Excel MVP

On Fri, 28 May 2010 04:03:01 -0700, scout ron <scout
wrote:

I was working on my scouts accounts file which previously I have no problems
with then on completion of some addittions I asked it to be saved.BUT it kept
saying sheet is protected and I cannot alter it.
This is hppening a lot recently and as far as I am aware I have not asked
for protection on any of my workshets in my Microsot progs ie Word or excell

option 1:
check if the workbook is saved with blank password (no password given in the protect option). you can try this,

use short cut, Alt + R, then immediately press PW keys.
you will prompt for password window, leave blank and unprotect it. it might work

option 2:
get the password from the workbook master (adminstrator who saved with password).