Disabling password in Excel 2000

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

Using Excel 2000 and after activating a macro in another
open file, I cannot change any cells in another open file
I am working in without putting in a password to unprotect
the worksheet. However, I never setup a password and I do
not know what the password is. I never even setup a
password.

Any suggestions would be greatly appreciated.
 
Hi Paul!

See:
JE McGimpsey
http://www.mcgimpsey.com/excel/removepwords.html

On the right hand side of the page you'll see a link that allows the
download og AllInternalPasswords.xls.

Download that and have it open at the same time as the problem
workbook. From within your problem workbook use:

Tools > Macro > Macros
Select AllInternalPasswords
Run


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top