XLA problems
 

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

XLA problems
 

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

"Neil Bhandar" wrote in message
...
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