Help with custom functions

I have some custom functions in an excel spreadsheet that a couple people use for this particular template. I put these functions in the "Module" section. These functions work fine on my machine and another co-workers machine. We all use Excel 2003, but another co-worker, also on Excel 2003, will get the "#NAME" error whenever she tries to change the value of any of the cells that these functions use to calculate a value.

Please Login or Register  to view this content.

I haven't the slightest clue as to why it'd do this especially since it works fine for myself and my co-worker.

My guess is that her macro security settings are set to High, which would disable the macros, and therefore cause the error.

HTH

Jason

Originally Posted by jasoncw

My guess is that her macro security settings are set to High, which would disable the macros, and therefore cause the error.

HTH

Jason

Would that cause the formulas to show an error message as soon as she opens the file?

Nevermind, just tried it for myself. thanks a bunch! I was really stumped for a second. Glad its an easy fix.

No, the values would be preserved, but the first time she attempts to edit the cell, it will give the #NAME! error.

You can verify this by disabling macros when you open the file and see what happens.