I Need To Alter My Password In Excel Protect Sheet

D

Dasha

Can someone please tell me how to alter my "password" I have made it too long
and keep messing it up It's only in an Excel "Protect Sheet" situation at
home in Office 2007 Excel Student and Home Use??? Thank's whilst hoping Dasha
 
R

Roger Govier

Hi

Providing you know your existing password, just unprotect the sheet using
that password.

Then when you protect again, give a new password.
If it is only for yourself, to prevent accidental overwriting of formulae or
other cell contents, then don't bother to give a password at all - it's
optional.
Just right click on sheet tab>Protect Sheet>OK

If you have lost your password, there are plenty of tools available to
unprotect sheets with a password. It is not something that is totally
secure.
If you need to do this, then go to J E McGimpsey's site
http://www.mcgimpsey.com/excel/removepwords.html
 
Top