I have an excel file that I have distributed to several collegues at work. We
currently use Excel 2002. The file utilizes several macros. One of the macros
is set up to remove the password. Here's the code:

ActiveWorkbook.SaveAs Filename:=strWrkBkName, FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False

What is interesting is that on some of my collegues computers the password
is removed but on others it is not! I even tried to remove the password
manually but with no success. I initially thought the problem might be a
service pack issue so I checked the computers where the password was removed
vs where it wasn't. There were some computers that had SP1 that did remove
the password as well as some that didn't. SP3 installed on some others, but
both cases were evident. My computer doesn't have any service packs
installed, but password removal works as advertised.

If anybody has any suggestions, your help would be greatly appreciated. Thanks