Application.Caller to get worksheetName where button is placed

[jaryszek]

Hi Guys,

in worksheet i have button and assigned macro to it (in module):

Please Login or Register  to view this content.

Code is not working.

When i try to set up called_by i am getting Type Mismatch error (13).
How can i do this?

Please help,
Jacek

[romperstomper]

Application.Caller returns the name of the button, not the button object. Since you can't click a button without its sheet being active, I can't really see why you don't just use activesheet?

[jaryszek]

Ooo thank you.

So simple...

Best,
Jacek