Column Widths

[LAF]

I work on a tool which is used worldwide. The tool is protected so that
they cannot change formulas, formatting, etc. We recently changed the
formatting of some of the columns to display 2 decimals. We had also
changed the column width to account for the 2 decimals. However, it
seems there are some countries that have very large numbers and the
columns are not wide enough so it displays ####. Because the tool is
protected, they cannot change the column width. Is there a way that
the column can be automatically adjusted to account for the large
numbers?

 

[Arien]

You'd better contact the person who protected the sheet. Thats the onl
way.

regards,
Arie

 

[LAF]

We own the code and can change the column widths manually, but is ther
a way to create some code to allow the user to change the column widt
or to change it to what width is necessary in order to display th
data

 

[Dave Peterson]

Maybe format the cell using:
format|cells|alignment tab|and check Shrink to Fit.