how to create this new functions

[jackni]

is there anyone can help me to create this new functions that can get the same result as the original functions in excel.
the new functions name is up to you, and i want someone can help me to write the vba of this functions such as "if, match, offset, address, indirect, countifs, sumifs, iferror"
can anyone in this forum help me, many thanks !!!

 

[kpark91]

Why would you ever want to write new functions when you already have working ones in VBA?

 

[wigi]

Why would you want to rewrite what was already done (and works fine)?

 

[VoG]

Homework?

 

[kpark91]

Dim homework$
homework = InputBox ("Is it homework? (Yes or No)")
 
If Lcase(homework) = "yes" Then
    MsgBox "Good luck!! Look at my signature for solution."
ElseIf LCase(homework) = "no" Then
    MsgBox "... Why??"
Else
    MsgBox "YES OR NOOOOOOO", vbCritical
End IF

 

[jackni]

Re: how to create these new functions

well, it's kind of difficult to explain.
here is the story. i want to protect my excel from cracked by someone else, and the most useful information in the workbook is the formula. my way to protect this workbook is kind of armed to the teeth. first, i want to rewrite the whole functions in excel, that means use all new functions created by myself instead of using the original ones, that's way i ask for help here. second, use macro to protect the workbook. third, use vb to package excel as a .dll file. so use new functions is one of these steps to protect.
is anyone can help me here? thanks!

 

[kpark91]

Re: how to create these new functions

1) If a ******* has access to the file where the password is stored, he/she will crack into anyways.
2) VBA project is extremely easy to crack into with the right applications or cannot mention it.
3) dll files are written in VB.NET, which is a totally different language altho rooted from the same language, BASIC

 

[jackni]

i know there is no perfect or absolute way to protect excel, new functions is just a way to make it harder or slower to ******* to totally get to know what is about in this workbook. besides, my workbook is not that kind business secret. what i'm doing is to prevent from normal users.
so the doubt remains, and is the vba language of writing these new functions difficult? 'cause i can not find any info.（answers） about it in internet.
in my early thought, i mean we can look at this question as a homework, if in this way, the answers will be easy to get. well, the reality is not like what i thought.
i'll be greatly appreciated if someone can help me ! thanks!