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

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.

:rolleyes: 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.

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

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 :duck:

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.

Yes :)