Excel VB

I am developing a metrics tracking database in excel.  I have multiple worksheets, some that need to be consolidated or eliminated, but that is not the point, as it is still a work in progress. The firs issue I am having is that one worksheet, Home, needs to be the first worksheet that is opned everytime regardless of what worksheet was editited and saved in the previous session.  I don't want users being invited to dig around in other worksheets.  I created some vb script and put it at the top of that sheet that looks like this:

Private Sub Workbook_Open()
Sheets("Home").Activate
End Sub

simple but it doesn't work.  It won't open the file to the HOME worksheet everytime.

The second issue is that I created "Main Menu" buttons to return the users back to the home worksheet.  My problem is that when they click on that button and then navigate back to that worksheet they are looking at the main menu button.  How do ensure that everytime one of the three dashboard reoprts are open, Dashboard, HBUS Dashboard and HBCAdashboard are opened they open at the top of the sheet?  Is it as simple as writitng code into each sheet activiating cell A1?
Prouduction-IM-METRICS-T-V01.xlsm
Rrave26Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder than dirtCommented:
That code needs to be in ThisWorkbook, not the sheet.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Martin LissOlder than dirtCommented:
As for your second question, yes, it's that simple or you could to this after activating the sheet

activewindow.scrollrow=1
0
Rrave26Author Commented:
Well that did it, thanks for helping a newbie out.
0
Martin LissOlder than dirtCommented:
You're welcome and I'm glad I was able to help. We are all newbies in the beginning.

In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

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.