Cursor position not expected?

[Aland2929]

If the cursor is positioned in cell K10 in the Dashboard sheet and I return to the main menu & click the Dashboard button, I would have expected the cursor to be positioned in cell B2 but it is not? What am I missing?

Please Login or Register  to view this content.

Thanks in advance

[HaHoBe]

Hi, Aland2929,

your code works fine in my version of Excel2007.

If itīs always Range B2 you want to go to you could give this a try:

Please Login or Register  to view this content.

By adding Scroll:=True you may change that cell to be the upper left cell to be displayed.

Ciao,
Holger

[Aland2929]

Thanks for your reply. Where do I put: Scroll:=True?

[HaHoBe]

Hi, Aland2929,

place the command like this

Please Login or Register  to view this content.

HTH,
Holger

[Aland2929]

Thanks very much.