Password Protection Bug

S

spikefuzzy1

I am using MS Office (Pro) Excel 2003 (11.8237.8221) SP3
I create a new workbook.
I password protect the first sheet using the password "az" without the
quotation marks.
The sheet is now protected.
I unprotect the sheet and, when prompted for the password, input "Aj"
without the quotation marks.
The sheet is now unprotected.
Why does this other password work for unlocking the worksheet?
(There are other examples. For instance, "test" can be unlocked using "BBAb")

Why the heck does this work?
 
S

Shane Devenshire

Hi,

This is a know limitation of the password handling routine in Excel. The
good news?, its consistant between version, the same problem occurs in 2007.
Aparently Microsoft doesn't consider sheet passwords a critical issue.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

protection 2
Code to format cells on several worksheets 2
Qualifying permissions in protect unprotect macro. 4
Worksheet Protection & Sorting 0
using autofilter and sort, while sheet is protected 0
Protect Cells 10
Password Protection 7
Spell Check Protect Reprotect with same settings 1

Top