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

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
Omar HernandezAsked:
Who is Participating?
 
Martin LissConnect With a Mentor Older than dirtCommented:
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
 
KoenChange and Transition ManagerCommented:
vba is password protected... and gives errors...not the best way to present a solution
0
 
Omar HernandezAuthor Commented:
Thanks again Marty, works like a charm...
0
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.

All Courses

From novice to tech pro — start learning today.