Hi Guys.
I need your help.
I need to distribute a macro.
I am planning to creat an add-in.
This macro creates a button in the workbook that runs it.
My problem is: The Macro in the add in can?t identify the workbook?s name (the workbook that is calling).
Instead of creating the button in the main workbook it is creating inside the add in sheet.
I tried to use ThisWorkBook and ActiveThisWorkbook commands, but it doesn?t work (it gives me back the add in workbook?s name)
If I could creat a way that when the add in runs, it identifies the name of the workbook that is calling it, I could use this procedure in my VBA code, and the button would appear in the right place.
Any ideas?
Thank you.