Results 1 to 9 of 9
  1. #1
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hijack Excel built-in Worksheet function? (All)

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

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Hijack Excel built-in Worksheet function? (All

    Please define "hijack" and what your intention is?
    Jerry

  3. #3
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hijack Excel built-in Worksheet function? (All

    "hijack" means "replace".

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Hijack Excel built-in Worksheet function? (All

    OK, news to me <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

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

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Hijack Excel built-in Worksheet function? (All

    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

  6. #6
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hijack Excel built-in Worksheet function? (All

    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.

  7. #7
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Hijack Excel built-in Worksheet function? (All

    Howard

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

  8. #8
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hijack Excel built-in Worksheet function? (All

    Ayup, it did not work.

  9. #9
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hijack Excel built-in Worksheet function? (All

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •