Reply to thread

Message: [QUOTE="Arvi Laanemets, post: 11959600"] Hi I use only worksheet protection and VBA Project protection. But all my workbooks are created in Excel2000, and must remain in Excel2000 format - I'm not sure how good is compatibility with earlyer versions in Excel2007. I have encountered a couple other problems too with Exce2000 files. I posted them in microsoft.excel.programming: "Excel2000 procedure in Excel2007" at April 14. "Excel2000 worksheet Change event doesn't work in Excel2003 or higher" and "Excel 2000 vs 2003 date format issue (reposted)" at April 29. I did get workbook working properly in Excel2003 (simply redesigning the workbook from scratch, without any changes), but with Excel2007 it doesn't work properly jet. Yesterday I added password removing (as all sheets in workbook are protected, I got an idea from current post, that maybe this is the cause for problems) into Change event, but it didn't have any effect. [/QUOTE]