Solved

Would like that on the window button to have a userform to give me option which one to open.

Posted on 2016-11-01
3
37 Views
Last Modified: 2016-11-02
Hello there Experts Exchange,

---I Would like that on the window button to have a userform to give me option which one to open.
Omar-arrange.xlsm
0
Comment
Question by:Omar Hernandez
3 Comments
 
LVL 46

Accepted Solution

by:
Martin Liss earned 500 total points
ID: 41869541
Give this a try.  When the workbook opens, click the "Windows" button (the one on the right of the "ON" button). When you do, a userform will appear and you can choose the worksheets that you want to see.

Inside the UserForm_Terminate sub of the new userform named frmShow you'll find two CONSTs that you can change to suit your display.
28980395.xlsm
0
 
LVL 8

Expert Comment

by:Koen
ID: 41869996
vba is password protected... and gives errors...not the best way to present a solution
0
 

Author Closing Comment

by:Omar Hernandez
ID: 41870049
Thanks again Marty, works like a charm...
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Excel VBA User Form Help 21 27
Can anyone derive why this VBS doesn't work? 4 22
Word 2010 assign Hyperlink to Sub code 5 17
Msbbox Notice (4 days) 27 58
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

785 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