Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() My users have requested some special functions added to their Excel spreadsheets. I've added a module to the spreadsheet and written 6 functions to handle the user's requirements. The code ran fine yesterday. After closing the spreadsheet and reopening it, the value of the functions is appearing as #NAME?. The VB code is still there as it was yesterday, but the debugging functionality doesn't seem to work. When you go to the cell with the function and press F2 to Edit and press enter, the VB editor does not fire off the breakpoints. I've tried to recompile the VB code, but the Compile option from the Debug pull down menu option, but it's greyed out. I will be sending this spreadsheet out to my users for them to copy data from another spreadsheet. Thank you, in advance, for any help you all may be able to provide. Regards, James W. Hamersly, Jr. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
formula/functions for average and if functions | Excel Worksheet Functions | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
excel functions and User defined functions | Excel Programming |