Event procedures: who is calling?
 

Hi Excelers,
is there any way to find out whether a worksheet event procedure , e.g.
Worksheet.Activate, is triggered by

a. a user activating the worksheet

b. a macro activating the worksheet

c. a macro calling the event procedure?


TIA

Momo

Event procedures: who is calling?
 

Look into Application.Caller property

Dm Unseen

Event procedures: who is calling?
 

DM Unseen,
I did, and it doesn't give that information.

Momo