Well, moving all the code to the .BAS module doesn't work, like I
expected. The code in the .BAS module isn't being called at all.

First of all, I don't know where that file is saved. The VB editor
doesn't allow me to Save As, so it's not in the directory where the
spreadhseet is.

So I've got to reorganize the project somehow.

On Jun 18, 1:40 pm, Dave Peterson wrote:
The code for the UDF belongs in a General module if you want to call it from a
formula in a cell.

If you have that same code behind a worksheet or behind ThisWorkbook, it
probably can be deleted with no problems--but you'll want to test.

As for the rest of the code, I didn't see anything that would indicate that it
belongs in one spot or another. So it would be difficult to guess.

cappy2112 wrote:

I understood your reply, however, that applies to the version number
function I want to call from the Spreadsheet.

Are you also suggesting that I put the existing code (the code that
was in place before I started maintaining this project)
in a new module as well?

On Jun 18, 12:51 pm, "Chip Pearson" wrote:
Do NOT put the code in the code module associated with a worksheet. Re-read
my replies. You need to CREATE A NEW MODULE.

--

Dave Peterson