I was wondering how I can stop making the Bid, ASK and Last field automatically populate from the...

Options
mjc
mjc Newcomer
in REDI API
I was wondering how I can stop making the Bid, ASK and Last field automatically populate from the REDI API in my order entry tool in excel, it might be coded into the VBA somewhere in the sheet, i am not sure how to fix it
Tagged:

Best Answer

  • zoya faberov
    zoya faberov ✭✭✭✭✭
    Answer ✓

    Hello @mjc,

    Use

    Menu -> Developer -> View Code

    to edit code.

    From the code, you task will depend on the extent of what you are looking to achieve.

    If you are just looking to prevent DDE price updating, making your sheet lighter:

    Then from Workbook_Open method, comment out "AddDDE" call. The updates will not be triggered.

    'AddDDE

    If you are looking to remove ASK BID LAST columns from the sheet completely:

    Then after you remove the columns, the remaining columns will shift, and you will need to update every reference within sheet code to the new valid coordinates, shifting by the removed columns, in your case it may be by 3, for example every "D" will become "A" while every "L" will become "I".

Answers

  • mjc
    mjc Newcomer

    Hello, thank you that works, however once i click the clear status button to do new orders the DDE links reappear, maybe i need to do something in the Clear Status Sub to make it not repopulate the links?

Categories