Make Custom Macro always Available

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PowerPoint Shuffle (swap) objects on PPT slides with the same name only 0
Ron's between function in excel.. 13
Excel VBA - counting cells by colors and names to it in two different rows. 0
Need to fix macro to list data underneath each other 17
How to check to see if a sheet with a particular name exists? 3
How to write a macro that will clear validated cells to blank? 3
Insert blanks, but populate new blank rows in one column 6
Excel VBA Funtion parameter input 0

Back
Top