XLA problems

  • Thread starter Thread starter Neil Bhandar
  • Start date Start date
N

Neil Bhandar

Hello:

I developed a very basic tool in XLS, toolbar & menu
option.

I converted the XLS to an add-in (XLS file) but each time
I hit the button on the toolbar it opens up the orig XLS
file.

I tried renaming the orig XLS file, the macro behind the
button fails. Seems like for some reason the macro still
points to the original XLS. Any thoughts?

Thanks in advance,
-Neil
 
Neil,

How are you referring to the add-in workbook?
Using "ThisWorkbook" works for me, something like...

MenuButton.OnAction = ThisWorkbook.Name & "!ToggleWordWrap"
(note the exclamation point)

Regards,
Jim Cone
San Francisco, CA
 
Back
Top