Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

MS Excel Position cursor in Cell C2 in all sheets in a workbook

Posted on 2013-11-14
2
Medium Priority
?
416 Views
Last Modified: 2013-11-14
I am looking for a macro that would place the cursor in Cell C2 of all sheets of a workbook when the file is opened -- regardless of where the cursor was at the time of save. I also need the first sheet of the workbook to be in focus when the file is opened. I currently have the following code running for "all worksheets"; however, when the file is opened, the last sheet is in focus (instead of the first). Any help is greatly appreciated!

Private Sub Workbook_Open()
Dim WSheet As Worksheet

For Each WSheet In Worksheets
WSheet.Activate
Range("C2").Select
Next
End Sub
0
Comment
Question by:jaguar5554
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 35

Accepted Solution

by:
Norie earned 2000 total points
ID: 39648796
Try this.
Private Sub Workbook_Open()
Dim I As Long

    For I = Worksheets.Count To 1 Step -1
        Application.Goto WorkSheets(I).Range("C2"), Scroll:=True
    Next I

End Sub 

Open in new window

0
 

Author Comment

by:jaguar5554
ID: 39648808
That is perfect.  Thank you very much.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question