Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User-Defined function not working
I am trying to get a user defined functione to work in
excel and all I get is #NAME. I am using Office XP (Excel 2002) I have simplified the function to a minimum (here is the code): Public Function User() ' Returns the name of the current User User = Application.UserName End Function I have tried the following: - Set Macro security to Medium and then to low. - Digitally signed the code using a key generated by SELFCERT.exe - Everytime I have changed the secucrity settings I save the spreadsheet, closed it and re-opened it. So far nothing works can anyone offer some insight? Thanks .. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User-Defined function not working
Guy,
If you are trying to put the value of this function into a cell on a sheet, then make sure that the cell formula is =User() By the way, I usually prefer to name my custom functions something like ufUser (for "User Function") just in case "User" is a reserved name in Excel. Salut, Alex@JPCS "Guy Gagnon" wrote in message ... I am trying to get a user defined functione to work in excel and all I get is #NAME. I am using Office XP (Excel 2002) I have simplified the function to a minimum (here is the code): Public Function User() ' Returns the name of the current User User = Application.UserName End Function I have tried the following: - Set Macro security to Medium and then to low. - Digitally signed the code using a key generated by SELFCERT.exe - Everytime I have changed the secucrity settings I save the spreadsheet, closed it and re-opened it. So far nothing works can anyone offer some insight? Thanks . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
User-Defined function not working
Make sure the function is in a general module and not in a worksheet module
or the ThisWorkbook module. As long as macros are enabled, should work. Regards, Tom Ogilvy Guy Gagnon wrote in message ... I am trying to get a user defined functione to work in excel and all I get is #NAME. I am using Office XP (Excel 2002) I have simplified the function to a minimum (here is the code): Public Function User() ' Returns the name of the current User User = Application.UserName End Function I have tried the following: - Set Macro security to Medium and then to low. - Digitally signed the code using a key generated by SELFCERT.exe - Everytime I have changed the secucrity settings I save the spreadsheet, closed it and re-opened it. So far nothing works can anyone offer some insight? Thanks . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
User-Defined function not working
Thanks for the tip. The problem I was having weas the
code was not in a General module rather it was in the worksheet. Cheers, Guy -----Original Message----- Guy, If you are trying to put the value of this function into a cell on a sheet, then make sure that the cell formula is =User() By the way, I usually prefer to name my custom functions something like ufUser (for "User Function") just in case "User" is a reserved name in Excel. Salut, Alex@JPCS "Guy Gagnon" wrote in message ... I am trying to get a user defined functione to work in excel and all I get is #NAME. I am using Office XP (Excel 2002) I have simplified the function to a minimum (here is the code): Public Function User() ' Returns the name of the current User User = Application.UserName End Function I have tried the following: - Set Macro security to Medium and then to low. - Digitally signed the code using a key generated by SELFCERT.exe - Everytime I have changed the secucrity settings I save the spreadsheet, closed it and re-opened it. So far nothing works can anyone offer some insight? Thanks . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Defined Function is not working for me in Excel 2007 | Excel Discussion (Misc queries) | |||
User Defined function - Help | Excel Worksheet Functions | |||
user defined function | Excel Worksheet Functions | |||
User Defined Function | Excel Discussion (Misc queries) | |||
User-defined function | Excel Worksheet Functions |