UDFs - need help to share functions with spreadsheet

[whelanj]

I'm trying to get my user defined functions to work in a spreadshee
that I'm sharing. They're are spreadsheet specific and I don't want t
use Add-Ins for the simplicity of having just one file.

I've seems lots of comments to "put you code in the workbook, it wil
save in the work book"... but I have no idea how to do this (yes, I'm
new excel/VB user).

Can someone give me a step-by-step?

Please? I don't want to beg but I will..

 

[Frank Kabel]

Hi
try the following:
- open your workbook
- open the VBA editor (hit ALT-F11)
- locate your workbook/project in the explorer tree view on the left
site
- insert a module for this workbook/project
- insert/paste your code in this workbook