Make Custom Macro always Available

B

bookman3

I have created the following simple custom macro below and saved it in a
module.
How do I make it always available for any workbook?

Function Between(a As Integer, b As Integer, c As Integer)
If a >= b And a <= c Then
Between = True
Else
Between = False
End If
End Function
 
D

Dave Peterson

Put the udf in a workbook that is always open when excel is open.

Lots of people put these things in a file named personal.xls and store that
workbook in their XLStart folder.

Then you can use:

=personal.xls!between(a1,b1,c1)
 
B

bookman3

Thanks
--
bookman


Dave Peterson said:
Put the udf in a workbook that is always open when excel is open.

Lots of people put these things in a file named personal.xls and store that
workbook in their XLStart folder.

Then you can use:

=personal.xls!between(a1,b1,c1)
Click to expand...
 
Top