Macro for PGUP function in browser(AJAX)

[r_wroblewski]

Hello Community

One problem I have to solve at the moment is that when enter a sheet the user will be on the top of the new sheet.

I know that basically the use of macro and scrolling should be avoided but in this case it is necessary.

I tried with:

Sub PGUP

  Set objShell=CreateObject ("WScript.Shell")

  objShell.SendKeys "{PGUP}"

End Sub

But the macro is not working on Sheet trigger or button.

I'm not very familiar with VBScript and not sure if there is an error in it or if I missed something.

Any advice is appreciated.

Best regards,

Ronny