In Excel while saving a Workbook, Wroksheet you can give a
PassWord.
You will get this option is Save As Dialog Box.
In that first you have to type a PassWord and then you have to
type the same PassWord as a Confirmation PassWord.
If you type some different PassWord in Confirmation then it will
give an Error. It means you have to type the same (Exact) PassWord
as a Confirmation PassWord.
But, while typing Confirmation PassWord if you type the whole Pass-
Word correct execpt the last character. Then, it will accept that
without an Error ? ? ?
e.g. PassWord is Amol Confirmation PassWord is Amod
Now, if you want try to Open a particular WorkSheet, Workbook you
have to type the acutal Password i.e. Amol in my example.

Then what is the use of Confirmation PassWord ? ? ?

Any suggestions ?

Thanx in Advance.