Home Article index Newsletter

Deze pagina in het NederlandsHome > Article index > Register UDFs >

Registering a User Defined Function with Excel

Put to Use

Now that I've explained some of the internals of this method, let me finish by showing you how this is put to use in your project.

This requires the following steps:

Private Sub Workbook_Open()
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
End Sub

Of course you can also use the old Auto_Open and Auto_Close subs in a normal module.

Next you fill in the details about your UDFs on the worksheet called FunctionList:

Some additional remarks:

Make sure you read the last page too, it contains an important warning!