Jean

Where did you place the code?

Right-click on the sheet tab and "View Code"

Copy/paste the code into that sheet module.

Switch to another sheet then back to first sheet to "Activate" the code.


Gord Dibben MS Excel MVP

On Sat, 29 Sep 2007 03:40:33 -0000, Jean wrote:

?B?TWlrZQ==?= wrote in
:

Paste this into the worksheet module
Private Sub Worksheet_Activate()
MsgBox "start to update this sheet"
End Sub

"Nancy " wrote:

Hi,



When I click on a tabsheet to open a sheet I would like that
automaticly u=one macro start to update this sheet.
It is possible?
Thank you in advance

Nancy



I try it but nothing happens!

Nancy