Compatability Issues XL97 - XP

[Steve Jones]

Is there a site you can view or find out about the differences between XL97
and XP.

I have just sent a file to a colleague and it is working fine in my version
of Excel 97. He is using Excel XP and some cells are coming up as protected
on his worksheet and not allowing him to do something.

This is not the only thing I have encountered of late between the versions.
Any help would be appreciated.

Thanks

Steve

 

[Dave Peterson]

I don't have a site that shows the differences, but this doesn't sound normal to
me.

Wild guess follows:

Do you have any helpful code that protects a worksheet with userinterfaceonly
set to true? In earlier versions of excel, you could do this without knowing
the password. In xl2002, you have to give it the password.

And you'd have to have something like an "on error resume next" to suppress the
error.

So this probably isn't the cause, but I don't think it's the xl97 vs. xl2002
that is causing it. (I'd keep looking.)