Word-Wrap Help?

[Victor Delta]

In a spreadsheet, I have one worksheet which contains a lot of data and
text. Another worksheet copies some of that info (using the LOOKUP function)
into a more manageable form for viewing and printing etc.

Some of the fields contain quite a bit of text and so, in the second
spreadsheet, I have formatted the cells using word-wrap so that all the text
is visible. This works well.

However, if I now add some additional text to one of the cells in the first
worksheet, the second worksheet does not automatically re-word-wrap, so the
end of the new text will be hidden. I have found that if I manually remove
the word-wrap and then reapply it, the cells adjust to show all the text.

So my question is - is there a way of making the worksheet automatically
adjust the word-wrapping when necessary?

If not, then I guess I could write a macro to do what I currently do
manually. If I do go down this path, is there a way to make a macro run
automatically when one clicks on the tab of a particular worksheet (i.e. the
second one, in this case)?

TIA

V

 

[Sheeloo]

You can sue Private Sub Worksheet_Activate()
which is executed when you click on the tab for the worksheet.

 

[Victor Delta]

You can sue Private Sub Worksheet_Activate()
which is executed when you click on the tab for the worksheet.

Many thanks. Does just what I wanted.

V

 

[Victor Lobo]

Many thanks. Does just what I wanted.

V

Hi

This issue does not occur in Excel 2007!

For 2003 this code below seems to work. Add it in the second sheet.


Private Sub Worksheet_Calculate()
Me.Rows.AutoFit
End Sub



Thanks,
Victor

 

[Victor Delta]

Hi

This issue does not occur in Excel 2007!

For 2003 this code below seems to work. Add it in the second sheet.

Private Sub Worksheet_Calculate()
Me.Rows.AutoFit
End Sub

Thanks,
Victor
------------------------------
Victor

Many thanks,

Victor