User Defined Functions
where do i place an add-in so it's always loaded? i didn't think that was
possible without manually adding the add-in.
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
scott
An add-in is a good way to go.
Copy/paste the UDF's to a general module in a new workbook.
Then FileSaveasSaveas File Type...scroll down to bottom of list and
select
Microsoft Excel Add-in(*.xla)
Gord Dibben Excel MVP
On Mon, 27 Dec 2004 16:25:40 -0600, "scott"
wrote:
I have a user that has about 10 custom functions. I'd like to create a
add-in to hold them and allow them to be used on any new or old
spreadsheet
he uses.
Is an add-in the best way?
|