Hijack Excel built-in Worksheet function? (All)

Topic

New Reply

Is it possible to hijack an Excel built-in worksheet function?

Reply | Quote

Replies

Please define “hijack” and what your intention is?

Reply | Quote

“hijack” means “replace”.

Reply | Quote

OK, news to me

So are you saying you want to overwrite a function so yours has the same name but a different calculation.

Reply | Quote

I don’t think you can use your own function instead of an excel one. I think it checks the builtin ones before checking the modules in the workbook for a name.

You can “hijack” a function from an addin (like the analysis toolpack) by creating one with the same name.

Steve

Reply | Quote

Thanx, I’ll try putting the code in a DLL.

Hmmm, I wonder if I could get by just putting the ccritter in a Class in personal.xls?
No harm in trying.

Reply | Quote

Howard

As for the Class idea, you can try, but it won’t work.

Reply | Quote

Ayup, it did not work.

Reply | Quote

When I pleaded my case, that when I forced my way into the cockpit, I simlpy intended to replace the 747, it didn’t wash.

Alan

Reply | Quote