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

"Victor Delta" wrote:

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