On Jan 17, 5:05*am, "Victor Delta" wrote:
"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in
...

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

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