Excel -All Sheets Same Destination

Hi,

Is there a way in a workbook, where there are numerous sheets, to move the cursor and the screen to a specified cell (e.g. A1). I can work so the cursor moves, but not necessarily the screen shot of all sheets.

Please advise.

Thanks.
tahirihAsked:
Who is Participating?
 
dlmilleConnect With a Mentor Commented:
I sometimes do this in a macro...  It just repositions the cursor to outside the screen, then back to A1 so the screen should settle properly...

Enjoy!

Dave

Sub ResetPositionOnSheets()
Dim mySheet As Worksheet

application.displayalerts = false

    For Each mySheet In Application.Worksheets
        mySheet.Activate
        Range("A60000").Select
        Range("A1").Select
    Next mySheet

application.displayalerts = true
End Sub
0
 
SiddharthRoutCommented:
tahirih: Could you please rephrase on what are your exact requirements?

Sid
0
 
tahirihAuthor Commented:
I use Excel 2007. Example - I have 5 sheets in one workbook.

Is there a way to select all, and have the page scroll up or down (dependent on where the cursor originally is on the sheet) to a specified cell so when I open all worksheets, I can see the same cell?

Thanks
0
 
dlmilleCommented:
See my post - it does it.

Dave
0
 
tahirihAuthor Commented:
Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.