name of workbook that play the macro

[vered]

hi

I WAND TO NOW THE NAME OF the WORKBOOK THAT PLAY THE MACRO

This_work = ActiveWorkbook.Name

THAT GAVE ME THE NAME OF THE MACRO

HOW CAN I GET THE NAME OF THE ONE THAT PLAY THE MACRO ON ????

 

[sericom]

ThisWorkbook.Name will give you the workbook name that the code resides in. ActiveWorkbook.Name gives you the name of the workbook that's active.