Results 1 to 4 of 4
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Enhance Excels Context Menu! (Excel 2000 >)

    Here is some code to modify and enhance Excels context (right click) menu. The code allows you to even enhance the menu if a user right clicks in a specific range. Try it out! (See the attached Workbook!)
    Regards,
    Rudi

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Enhance Excels Context Menu! (Excel 2000 >)

    Is the attachment working for you guys? When I run the attachment and test the code is is giving the following error?
    Regards,
    Rudi

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Enhance Excels Context Menu! (Excel 2000 >)

    I get no error message, but the custom menu item doesn't get deleted if you switch to another worksheet or workbook.

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Enhance Excels Context Menu! (Excel 2000 >)

    I've cleared up the error msg.
    Tx for pointing out the defect. This is another thing I'll have to work on tonight. Wow, I am going to be kept busy tonight, I have about 4 threads that I need to reply to with promises that I made to come back to!
    Cheers
    Regards,
    Rudi

Posting Permissions

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