Opening a workbook

Folks,
I have a workbook that I want to ALWAYS open to the tab labeled "Menu". How do I get there
Frank FreeseAsked:
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:
In Workbook_Open

Sheets("Menu").Select
Sheets("Menu").Activate

you may not need the Select.
0
Martin LissOlder than dirtCommented:
I just checked and all you need is the Activate line.
0
Martin LissOlder than dirtCommented:
So…


Private Sub Workbook_Open()

Dim intIndex As Integer

With Worksheets("Menu")
    For intIndex = 10 To .UsedRange.Rows.Count
        .Cells(intIndex, 1).Value = ""
    Next
    .Activate ' <=== Added this line
End With
ActiveWindow.ScrollRow = 10
Range("A1").Select

End Sub

Open in new window

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
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

Frank FreeseAuthor Commented:
great job
I'm enjoying the workbook - catching up on categories and topics
Made a few changes - when the workbook opens I clear to lblDescription and when I leave a topic I clear it again.
I will be back
0
Frank FreeseAuthor Commented:
Thank and as always your just the best
0
Martin LissOlder than dirtCommented:
YW.
0
Frank FreeseAuthor Commented:
Martin,
I am entering data and this design is awesome. Thanks again for all your hard work!
Frank
0
Martin LissOlder than dirtCommented:
Will all your users have the same version of Excel that you are using? If not then the macro I added for myself to set the listboxes back to their normal size after they become small should be integrated into the code. You've also never said whether or not you want to implement the process whereby when a cell in columns B or C on the menu sheet is double-clicked, the user is taken directly to the detail sheet for that item.
0
Frank FreeseAuthor Commented:
Not all users have the same Excel version.
I am having some problems with text sizes in the list boxes but I'm ignoring them at this time.
Help me on where this macro is and where to put the code, please.
The jury is still out on  to "implement the process whereby when a cell in columns B or C on the menu sheet is double-clicked, the user is taken directly to the detail sheet for that item." I can see value in that also. Different question anyway.
BTW, I showed what I have to my son last night and he was awestruck.
Once I get all my worksheets set up I'll be posting questions on managing printing and protecting (maybe an .exe file) the workbook.
0
Frank FreeseAuthor Commented:
Got me stumped?
Where do I go to add items to lstCategory?
0
Martin LissOlder than dirtCommented:
Topics column Z

I thought implementing my macro to resize the controls would be easy but I just found out that it's got problems. Hopefully I can fix them.
0
Frank FreeseAuthor Commented:
I knew I saw those somewhere - just another senior moment
Thanks for hanging in there
Goto other topics loaded now. I'll run out of columns before I get to Z but I'll try to figure out how to change the code to read a different column than Z. If I need help I'll ask
0
Martin LissOlder than dirtCommented:
All you need to do is insert as many columns as you need anyplace after L but before Z. The Name Manager will automatically adjust the formula that refers to Z and change it to the appropriate column.
0
Frank FreeseAuthor Commented:
Amazing - a simply great design.
0
Martin LissOlder than dirtCommented:
I believe I have a solution for the ActiveX controls changing size problem. When you are at a point where you can post your workbook and then wait until I update it with the solution, please let me know.
0
Frank FreeseAuthor Commented:
Here you go attached is the one I've using as the master.
Thanks - everything is going well so far.
Function-and-Formulas-for-Excel.xlsm
0
Martin LissOlder than dirtCommented:
Here's the update with the changes annotated with Q5. To make the process work you'll need to do the following just once.

1.    If necessary adjust the size, position, etc of the controls on the Menu sheet
2.    Find the new 'storeControlSettings' sub
3.    Select a row in that sub and press F5

You should then be shown a msgbox.
Function-and-Formulas-for-Excel.xlsm
0
Frank FreeseAuthor Commented:
thanks
in project mode now at work so I won't get a chance until I get home tonight
will advise then
0
Frank FreeseAuthor Commented:
which macro name do I need to choose? setControlsOnSheet?
Also, the workbook you returned has no tabs?
Or scroll bars? Interesting
0
Frank FreeseAuthor Commented:
hold on
for some reason I'm seeing things now?
0
Frank FreeseAuthor Commented:
The Excel I'm using is flaky - sometimes I get tabs, sometimes I do - lot of issues here at work. I'll test this on my workstation when I get home and advise
0
Frank FreeseAuthor Commented:
Favor please.
Before I post my question, please see if the attached file opens with tabs? It's the "orginal" file I had this morning with no changes made to it today. If you do not see tabs I'll post a question, else it must be this machine and this file.
Thank you
Function-and-Formulas-forExcel-R.xlsm
0
Frank FreeseAuthor Commented:
Everything seems to be working now - thanks for the additional macro - it must be my network workstation that is acting up from time to time
0
Martin LissOlder than dirtCommented:
The wb you posted opens and looks normal.
0
Frank FreeseAuthor Commented:
Go figure - question on its way
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.