Hi Hasnat,

This is a known bug. The 'fix' is to edit any cell and the mouse will focus on the worksheet again.

Mynda

Thanks Mynda.

As I was developing a template for my company routine work, I don't want the user gets stuck in such things.

So, I was trying to write a macro when the workbook will open it will go to a worksheet, do the double clicking/activate cell and also it will call Focus macro that I found in internet to shift focus. Codes below.

However, it didn’t work with Workbook Open. Can you please put some light what’s I am doing wrong here?

Private Sub Workbook_Open()

    Application.ScreenUpdating = False

    Sheets("Settings").Activate

    Range("A1").Select

    ActiveCell.FormulaR1C1 = ""

    Range("A2").Select

    Call Focus

    Application.ScreenUpdating = True

End Sub

Module:

Sub Focus()

Dim r As Range, rr As Range

Set rr = Range("A1:B1")    ' any empty range in the worksheet

For Each r In rr

     r.Select

     Application.SendKeys "{F2}"

     Application.SendKeys "{ENTER}"

     DoEvents

Next

End Sub

Regards,

Hasnat

Hi Hasnat,

If you tried the solution found on web, inluding:

Private Sub Workbook_Open()
ActiveWindow.SmallScroll down:=1
ActiveWindow.SmallScroll up:=1
End Sub

and it still does not work as you want, I'm afraid you will have to wait for the promised fix from Microsoft, make sure you update your version of Power Query, also for your users.

See this article for update cycle information: https://www.myonlinetraininghub.com/power-query-updates

Thanks Catalin,

It doesn't work with Workbook_Open though. 

Thanks for sharing PQ update info.