ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I create my own functions in Microsoft Excell 2003 (https://www.excelbanter.com/excel-programming/418416-how-do-i-create-my-own-functions-microsoft-excell-2003-a.html)

Kevin

How do I create my own functions in Microsoft Excell 2003
 
I am currently using excel to debug a program that I am writting. I want to
verify that the data is correct, but in order to do that I want to create a
compute distance function, which will take in 4 cells, which need to be in
order and return the distance.

My biggest hurdle is creating a custom function in Microsoft Excel 2003.
Especially given that when I use the help feature to accomplish this goal I
receive this message: This operation has been canceled due to restrictions in
effect on this computer. Please contact your system administrator.

Thanks for you help.

JLGWhiz

How do I create my own functions in Microsoft Excell 2003
 
Hi Kevin, it is probably related to your spyware. Most of the postings that
I have seen have identified their spyware settings as the problem. If your
seurity software allows you to disable the spyware, without affecting the
virus scan and junk mail features, try disabling it and see if that cures the
problem.

"Kevin" wrote:

I am currently using excel to debug a program that I am writting. I want to
verify that the data is correct, but in order to do that I want to create a
compute distance function, which will take in 4 cells, which need to be in
order and return the distance.

My biggest hurdle is creating a custom function in Microsoft Excel 2003.
Especially given that when I use the help feature to accomplish this goal I
receive this message: This operation has been canceled due to restrictions in
effect on this computer. Please contact your system administrator.

Thanks for you help.


Kevin

How do I create my own functions in Microsoft Excell 2003
 
I am uncertain what you are recomminding that I do. It sounds like I should
disable my spyware. I am unwilling to throw out this software in order to
write custom functions in excell. If you are familiar with spybot s&d, would
you tell me how to change the settings so that these two pieces of software
may coexist.

JLGWhiz

How do I create my own functions in Microsoft Excell 2003
 
There is some additional information at this site:

http://support.microsoft.com/?kbid=216583

"Kevin" wrote:

I am uncertain what you are recomminding that I do. It sounds like I should
disable my spyware. I am unwilling to throw out this software in order to
write custom functions in excell. If you are familiar with spybot s&d, would
you tell me how to change the settings so that these two pieces of software
may coexist.



All times are GMT +1. The time now is 06:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com