ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   xlUnlocked cells? (https://www.excelbanter.com/excel-discussion-misc-queries/19563-xlunlocked-cells.html)

Marc

xlUnlocked cells?
 
If I put xlUnlocked cells in workbook open, will it work in Excel 97?

Thanks in advance



Dave Peterson

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.)



Marc wrote:

If I put xlUnlocked cells in workbook open, will it work in Excel 97?

Thanks in advance


--

Dave Peterson

Marc

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



Dave Peterson

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.

Marc wrote:

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


--

Dave Peterson


All times are GMT +1. The time now is 06:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com