I thought this would be relatively simple, but I can't find an answer. I inherited some msp code that is reformatting some tasks in a project. The macro runs when the project_activate method is called,
What is happening is, If a user opens multiple projects, chooses for example start date on task 5 and then toggles between the 2 projects, the focus is somehow being reset back to the first column of the first task on the projectn and the users want the focus to stay where they left it.
without rewriting these macros, I thought I could get the row and column coordinates of the active cell or selection, store it in a variable, then after the macro runs just put the focus back with selectTaskcell. but I cannot find a way to get the row/column of the active cell.
any help is greatly appreciated.
What is happening is, If a user opens multiple projects, chooses for example start date on task 5 and then toggles between the 2 projects, the focus is somehow being reset back to the first column of the first task on the projectn and the users want the focus to stay where they left it.
without rewriting these macros, I thought I could get the row and column coordinates of the active cell or selection, store it in a variable, then after the macro runs just put the focus back with selectTaskcell. but I cannot find a way to get the row/column of the active cell.
any help is greatly appreciated.