Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 70
  • Last Modified:

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
0
Omar Hernandez
Asked:
Omar Hernandez
1 Solution
 
Martin LissRetired ProgrammerCommented:
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
 
KoenCommented:
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now