Start a macro when click on tab sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nancy - 28 Sep 2007 23:47 GMT

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

Reply to this Message

Mike - 29 Sep 2007 00:06 GMT

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

> Hi,
>
[quoted text clipped - 5 lines]
>
> Nancy

Reply to this Message

Jean - 29 Sep 2007 04:40 GMT

> Paste this into the worksheet module
> Private Sub Worksheet_Activate()
[quoted text clipped - 10 lines]
>>
>> Nancy

I try it but nothing happens!

Nancy

Reply to this Message

Gary Keramidas - 29 Sep 2007 04:51 GMT

put the code on the sheet that is activated when you click the tab,
for example, if you want the code to fire when you click on sheet2
then in the vb editor, double click sheet2 under ms excel objects and paste his
code there.

Private Sub Worksheet_Activate()
MsgBox "start to update this sheet"
End Sub

Signature

Gary

>> Paste this into the worksheet module
>> Private Sub Worksheet_Activate()
[quoted text clipped - 13 lines]
>
> Nancy

Reply to this Message

Gord Dibben - 29 Sep 2007 04:56 GMT

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

>> Paste this into the worksheet module
>> Private Sub Worksheet_Activate()
[quoted text clipped - 14 lines]
>
>Nancy

Reply to this Message