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
--
bookman

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)



bookman3 wrote:

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
--
bookman

--

Dave Peterson

Thanks
--
bookman


"Dave Peterson" wrote:

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)



bookman3 wrote:

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
--
bookman

--

Dave Peterson