How do I make a dialog box appear with options to select when a workbook is opened?

%3CLINGO-SUB%20id%3D%22lingo-sub-1306416%22%20slang%3D%22en-US%22%3EHow%20do%20I%20make%20a%20dialog%20box%20appear%20with%20options%20to%20select%20when%20a%20workbook%20is%20opened%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1306416%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20created%20a%20special%20calculator%20for%20my%20group%20in%20a%20work%20book%20with%20three%20different%20tabs.%20The%20calculator%20in%20each%20tab%20appears%20exactly%20the%20same%2C%20but%20has%20a%20different%20formula%2C%20specific%20to%20each%20tab.%20Just%20to%20make%20sure%20the%20members%20of%20the%20group%20are%20using%20the%20correct%20calculator%20without%20having%20to%20select%20the%20proper%20tab%20when%20they%20open%20the%20workbook%2C%20I%20would%20like%20to%20make%26nbsp%3Ba%20dialog%20box%20appear%20with%20a%20tab%20option%20to%20select%20when%20the%20workbook%20is%20opened%2C%20then%20open%20the%20tab%20they%20select%20from%20the%20dialog%20box.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1306416%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1306646%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20make%20a%20dialog%20box%20appear%20with%20options%20to%20select%20when%20a%20workbook%20is%20opened%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1306646%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20long%20as%20you're%20doing%20a%20selection%20from%20a%20drop-down%20dialog%20box%2C%20you%20could%20have%20it%20always%20go%20to%20the%20same%20calculator%20and%20have%20the%20formula(s)%20change%20depending%20on%20what%20option%20was%20selected.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20just%20a%20calculator%3F%20Or%20do%20the%20results%20of%20the%20different%20calculations%20on%20the%20different%20sheets%20get%20stored%20some%20place%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAn%20image%20doesn't%20usually%20go%20far%20enough%20for%20anybody%20to%20give%20substantive%20suggestions%2C%20but%20as%20you%20can%20tell%20from%20my%20opening%20thought%2C%20I'm%20not%20convinced%20you%20need%20separate%20sheets%20for%20what%20appear%20to%20be%20identical%20layouts.%20You%20can%20change%20the%20behind%20the%20scenes%20calculations%20on%20a%20single%20sheet....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I've created a special calculator for my group in a work book with three different tabs. The calculator in each tab appears exactly the same, but has a different formula, specific to each tab. Just to make sure the members of the group are using the correct calculator without having to select the proper tab when they open the workbook, I would like to make a dialog box appear with a tab option to select when the workbook is opened, then open the tab they select from the dialog box.

1 Reply
Highlighted

As long as you're doing a selection from a drop-down dialog box, you could have it always go to the same calculator and have the formula(s) change depending on what option was selected.

 

Is it just a calculator? Or do the results of the different calculations on the different sheets get stored some place?

 

An image doesn't usually go far enough for anybody to give substantive suggestions, but as you can tell from my opening thought, I'm not convinced you need separate sheets for what appear to be identical layouts. You can change the behind the scenes calculations on a single sheet....