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
21 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 45

Accepted Solution

by:
Martin Liss earned 500 total points
Comment Utility
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
Comment Utility
vba is password protected... and gives errors...not the best way to present a solution
0
 

Author Closing Comment

by:Omar Hernandez
Comment Utility
Thanks again Marty, works like a charm...
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Over the years I have built up my own little library of code snippets that I refer to when programming or writing a script.  Many of these have come from the web or adaptations from snippets I find on the Web.  Periodically I add to them when I come…
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.

771 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now