[RESOLVED] In an Excel 2003 Shared Workbook, can I have one Row excluded from edits being saved?

[SQLADOman]

In an Excel 2003 Workbook that I plan to change to being Shared on a Network Drive, I have Row(1) that I need to exclude from having edit changes saved.

Could I accomplish that by having "ThisWorkbook Save Event" fill the Row(1)Cells with the same set of default values during every Save?

I would just try it to find out, except its been 6 years since I last fiddled with a Share Workbook & I'd prefer not to learn how again if this will be an issue.

Thanks in advance for some insight.

[Siddharth Rout]

One way that I can think of... Since it is Excel 2003, declare as array of length 256 (256 columns). In the workbook open event store the values from row 1 in that array and in workbook close event write the values back to that row from the array....

[SQLADOman]

Ok great.. It's actually only Cell A1 through G1 that I have to accommodate.

If you feel nearly sure that your idea would work, then I guess I had better get off my tail, and re-learn how to configure my workbook as shared, so I can try it

ANOTHER QUESTION ON THIS:
I will soon convert to Excel 2007. Will a 2007 Shared workbook behave the same as in 2003 in this situation? Again it's only Cell A1 through G1, not the entire row.

[Siddharth Rout]

Yes