On Mon, 3 Sep 2007 05:56:00 -0700, Creating Functions in Excel
m wrote:

Hi,

Thanks. Sorry if I sound dim, but how do I insert functions into standard
modules rather than workbook or worksheet modules?

Jim

After opening the VB Editor, and selecting your project, you select
Insert/Module and enter your code into the window that opens.

In the subtree under your project, you will see something like:

VBAProject(Book2)
Microsoft Excel Objects
Sheet1
Sheet2
ThisWorkbook
Modules
Module1

Your code should be in "Module1"
--ron