Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
aauugghhh...#div/o problems & various average formula problems | Excel Worksheet Functions | |||
Fix Your Problems!!! | Excel Discussion (Misc queries) | |||
SP3 problems | Excel Discussion (Misc queries) | |||
VBA problems | Excel Discussion (Misc queries) | |||
Problems with VBE - Please Help | Excel Programming |