View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Excel workbooks and programming upward compatible?

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" wrote in message
...
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.