Mike,

Code written in Excel 97 should work fine in 2000. However,
without knowing what the error is and the code that is causing
the error, it is impossible to offer much advice.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"mike allen" wrote in message
...
i have applications written in excel2000, but when someone else
runs it on
excel97, it has problems w/ the macros. analysis tool paks are
enabled.
the code works some of the time, but eventually stumbles across
something it
doesn't like, but i cannot debug it. my ap is protected (of
course), which
disallows me to get into the code on the 97 computer. when i
go to vbeditor
and click on the project, it says "Project Locked" "Project is
unviewable"
1) how do i get into the code w/in 97?
2) why doesn't code work in both. i thought 97 and 2000 were
basically the
same.
thanks, mike allen