UDFs - need help to share functions with spreadsheet

  • Thread starter Thread starter whelanj
  • Start date Start date
W

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..
 
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
 
Back
Top