Custom Function
Hi
I have a couple of custom functions that i have saved in my Personal.xls workbook. Is there a way of making these public so i can call them from any workbook? When I try calling it from a workbook I get the message 'Name?' |
Custom Function
Edgar,
You need to precede the macro with the workbook name, =Personal.xls!myFunc(myparam) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Edgar" wrote in message ... Hi I have a couple of custom functions that i have saved in my Personal.xls workbook. Is there a way of making these public so i can call them from any workbook? When I try calling it from a workbook I get the message 'Name?' |
Custom Function
You need to qualify the macro name with the workbook name (unless the
file is an add-in). E.g., =Personal.xls!MyFunction In article , "Edgar" wrote: Hi I have a couple of custom functions that i have saved in my Personal.xls workbook. Is there a way of making these public so i can call them from any workbook? When I try calling it from a workbook I get the message 'Name?' |
Custom Function
=personal.xls!Myfunctionname(arg1, arg2)
Or put them in an Addin and load the addin. Then you won't need the filename. -- Regards, Tom Ogilvy "Edgar" wrote in message ... Hi I have a couple of custom functions that i have saved in my Personal.xls workbook. Is there a way of making these public so i can call them from any workbook? When I try calling it from a workbook I get the message 'Name?' |
Custom Function
make it an add-in
"Edgar" wrote in message ... Hi I have a couple of custom functions that i have saved in my Personal.xls workbook. Is there a way of making these public so i can call them from any workbook? When I try calling it from a workbook I get the message 'Name?' |
Custom Function
How easy is it to put these functions in an addin?
Does any one know of a guide to doing this? TIA -----Original Message----- =personal.xls!Myfunctionname(arg1, arg2) Or put them in an Addin and load the addin. Then you won't need the filename. -- Regards, Tom Ogilvy "Edgar" wrote in message ... Hi I have a couple of custom functions that i have saved in my Personal.xls workbook. Is there a way of making these public so i can call them from any workbook? When I try calling it from a workbook I get the message 'Name?' . |
Custom Function
Just open a new workbook, move the macros to that workbook. Then save that
workbook as an addin, it is the last file type in the list. Then goto ToolsAddin and browse for that newly saved file to install it. Tick the selection, and you are away. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Edgar" wrote in message ... How easy is it to put these functions in an addin? Does any one know of a guide to doing this? TIA -----Original Message----- =personal.xls!Myfunctionname(arg1, arg2) Or put them in an Addin and load the addin. Then you won't need the filename. -- Regards, Tom Ogilvy "Edgar" wrote in message ... Hi I have a couple of custom functions that i have saved in my Personal.xls workbook. Is there a way of making these public so i can call them from any workbook? When I try calling it from a workbook I get the message 'Name?' . |
All times are GMT +1. The time now is 11:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com