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

Posted on 2016-11-01
Medium Priority
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.
Question by:Omar Hernandez
LVL 52

Accepted Solution

Martin Liss earned 2000 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.

Expert Comment

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

Author Closing Comment

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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

There are times when I have encountered the need to decompress a response from a PHP request. This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
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 how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

624 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