Hi Guys,
This is my first post here so I'll start with 'Hello' to everyone!
I created a couple of custom functions and store them in xlam file saved as Excel's add-in. It lets me use all of custom functions in every workbook on my computer - that's cool. The problem is, however, when I send those workbooks to someone via mail. Instead of correct result of custom function they would display error because xlam add-in with function's definition is not present on remote computer. I'm looking for a way to replace all the cells that contains custom function with their value. It would be great if this could be done from within the fuction - e.g. the code in function would replace cell with value. Unfortunately this brings circular reference warning. It makes sense - the function can't replace itself with value during runtime. What else can I do? I want it to be extra-simple as there are is few inexperienced users using my functions that would find it difficult to e.g. fire a replacing macro at end of the work.
I'll be grateful for help.
Robert
This is my first post here so I'll start with 'Hello' to everyone!
I created a couple of custom functions and store them in xlam file saved as Excel's add-in. It lets me use all of custom functions in every workbook on my computer - that's cool. The problem is, however, when I send those workbooks to someone via mail. Instead of correct result of custom function they would display error because xlam add-in with function's definition is not present on remote computer. I'm looking for a way to replace all the cells that contains custom function with their value. It would be great if this could be done from within the fuction - e.g. the code in function would replace cell with value. Unfortunately this brings circular reference warning. It makes sense - the function can't replace itself with value during runtime. What else can I do? I want it to be extra-simple as there are is few inexperienced users using my functions that would find it difficult to e.g. fire a replacing macro at end of the work.
I'll be grateful for help.
Robert