Excel workbooks and programming upward compatible?

[Steve]

I have application workbooks created in Excel 2003 for the individual use of
multiple people. One or two users have Excel 2007, and more may be up
switching (I hesitate to use "upgrading"). There are buttons which process
data and do other things. However not all things work correctly in Excel
2007. Are there known issues, service packs, or references that need to be
added to Excel 2007 to make it backward compatible? Where can I find that
info? Or is it problematic programming?

One issue is that worksheet protection does not turn back on at the end of a
macro after being turned off at the beginning.

 

[Peter T]

In theory most code written in previous versions should work in Excel 2007.
Unfortunately there's a lot that may need to be modified and I don't know of
a single resource that tell you all you need to know. Afraid it means
thoroughly testing in 2007 until it works.

One issue is that worksheet protection does not turn back on at the end of
a
macro after being turned off at the beginning.

That does not occur automatically in any version

Regards,
Peter T

 

[Steve]

So if there is no single resource of upgrade issue info, do you have any
resource suggestions at all?

I know that worksheet protection off/on is not automatic in macro
processing, and I have it in the code (off at beginning of macro, on at the
end) and no problem in Excel 2003. However in 2007 it doesn't always turn
back on.