Issue:
I am trying to create an add-in with some useful functions I want to call from either tables or from other macroses.
What is done:
1) File is saved as XLA in add-in folder; add-in is turned on in Tools-Add-ins
For the test purposes, there is only two macro:
ColumnNumberToLetter
MsgBoxWithColumnToLetter
Second macro just calls the first and displays a message with result
2) Button on a toolbar linked to the MsgBoxWithColumnToLetter, works fine
3) When calling a function from table, sometimes it works, but sometimes either gives #VALUE? error message or an empty result (I mean, there's a function in the cell, but the cell looks empty)
4) When I call any of an add-in macro from VBA, I get "Compile error: Sub or Function not defined"
5) When I try to reference an add-in in VBA through Tools - References, I get "Name conflicts with existing module, project, or object library"
What am I missing ?
I am trying to create an add-in with some useful functions I want to call from either tables or from other macroses.
What is done:
1) File is saved as XLA in add-in folder; add-in is turned on in Tools-Add-ins
For the test purposes, there is only two macro:
ColumnNumberToLetter
MsgBoxWithColumnToLetter
Second macro just calls the first and displays a message with result
2) Button on a toolbar linked to the MsgBoxWithColumnToLetter, works fine
3) When calling a function from table, sometimes it works, but sometimes either gives #VALUE? error message or an empty result (I mean, there's a function in the cell, but the cell looks empty)
4) When I call any of an add-in macro from VBA, I get "Compile error: Sub or Function not defined"
5) When I try to reference an add-in in VBA through Tools - References, I get "Name conflicts with existing module, project, or object library"
What am I missing ?
