I have an excel spreadsheet that has been developed to load into an Access database using macros but it has to be sent out to all our suppliers so I HAVE to have it protected (Protect Sheet - with password).
Problem is that the Description column isn't always wide enough to accomodate the whole description so I have it set up to word wrap and automatically resize the row. This works on my machine but doesn't work on one of the suppliers machines.
When she types into the field and it exceeds the column width, it wraps while she's editing but when she hits enter, it spreads it out across the full line and doesn't resize the row.
When she saves it and sends it to me, the problem is saved as well and it acts the same for me....even though the original doesn't.
Do you have any idea what the problem is and what I can do to fix it?
Thank you in advance.
"The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents."
-Nathaniel Borenstein
Problem is that the Description column isn't always wide enough to accomodate the whole description so I have it set up to word wrap and automatically resize the row. This works on my machine but doesn't work on one of the suppliers machines.
When she types into the field and it exceeds the column width, it wraps while she's editing but when she hits enter, it spreads it out across the full line and doesn't resize the row.
When she saves it and sends it to me, the problem is saved as well and it acts the same for me....even though the original doesn't.
Do you have any idea what the problem is and what I can do to fix it?
Thank you in advance.
"The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents."
-Nathaniel Borenstein