Column Widths

L

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?
 
A

Arien

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

regards,
Arie
 
L

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
 
D

Dave Peterson

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