If I put xlUnlocked cells in workbook open, will it work in Excel 97? Thanks in advance
M Marc Mar 29, 2005 #1 If I put xlUnlocked cells in workbook open, will it work in Excel 97? Thanks in advance
D Dave Peterson Mar 29, 2005 #2 It should. But a better design rule is to develop workbooks on the oldest version of excel that the user's will be running. There are some things that were added in xl2k+ that won't work with xl97. (This isn't one of them, though.)
It should. But a better design rule is to develop workbooks on the oldest version of excel that the user's will be running. There are some things that were added in xl2k+ that won't work with xl97. (This isn't one of them, though.)
M Marc Mar 29, 2005 #3 Thanks Dave, Also, in Excel 97, does it work protect VBA project? I have Excel 2003, and I have protected project. Shall it work in Excel 97? Thanks
Thanks Dave, Also, in Excel 97, does it work protect VBA project? I have Excel 2003, and I have protected project. Shall it work in Excel 97? Thanks
D Dave Peterson Mar 29, 2005 #4 Does it work ok in a workbook with a protected project? Yes. But the real best way to test this kind of stuff is to try it with xl97.
Does it work ok in a workbook with a protected project? Yes. But the real best way to test this kind of stuff is to try it with xl97.