Hi All

Can I set the format of a user's "Regional Options - Short Date" from
Excel?

As far as I can work out it seems all you can do is ask Excel for a
short date and then it depends on the "Regional Options" of the user
whether a 2 digit (yy) or 4 digit (yyyy) year is displayed.

I have tried a custom format of "dd/mm/yy" but this just slips back to
a short "Date" cell and then displays based on the "Regional Options".

This caused me problems as my columns will not be correcly sized for
users with a short date of "dd/mm/yyyy" which is the standard Windows
setting. Column width is of the essence for presentation reasons.

In the past I have manually changed the Short Date configuration for
users but this does not scale of course and is completely impractical
for remote users.

Can I set the format of a user's "Regional Options - Short Date" from
Excel? Or should I just do an AutoFit on my date columns on
Worksheet_Activate?

Thanks for any advice,
Chrisso