none
Jump to the first activity RRS feed

  • Question

  • Hi,

    I though it would be quite simple, but for some reason I cannot crack this.

    when I apply a filter in my plan, many times the screen is empty and I need to scroll all the way up to see the tasks.

    is there a simple VBA code that I can use to do the scrolling so the cursor will be placed on the first row?

    Thanks,

    Yuval

    Monday, March 2, 2015 2:30 PM

Answers

  • just played some more and found this command that works:

    SelectBeginning

    regards,

    Yuval

    • Marked as answer by Yuval.p Monday, March 2, 2015 2:37 PM
    Monday, March 2, 2015 2:37 PM

All replies

  • just played some more and found this command that works:

    SelectBeginning

    regards,

    Yuval

    • Marked as answer by Yuval.p Monday, March 2, 2015 2:37 PM
    Monday, March 2, 2015 2:37 PM
  • Hi Yuval,

    Here is a code sample by John (he should have credit for that) I found in an old thread. You could enter 0 as the task ID if you use to display the project summary task. This returns a message in case the task is filtered out.

    Sub gototest()
    On Error Resume Next
    EditGoTo ID:=[TASK ID]
    If Err > 0 Then
    MsgBox "this task isn't available in the current view structure"
    Else
    End If
    On Error GoTo 0
    End Sub


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |


    Monday, March 2, 2015 2:42 PM
    Moderator
  • Guillaume,

    I'm not aware that I threatened anyone but I have "threaded" a few people :-)

    John

    Monday, March 2, 2015 3:10 PM
  • Indeed you have! Just corrected the typo, my English is really poor... :-(

    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |

    Monday, March 2, 2015 3:15 PM
    Moderator