EE Excel Professionals;
I recently saw a great short video about the power of the calculator function in Excel (not the simple calculator but the one that can do both scientific and business functions by changing the type of calculator in the help fuction). I'm looking for how to embed the calculator function into a spreadsheet, automatically have it come up with the right template (i.e. business or scientific) and have a button (macro) that pops it up when it is needed within a particular sheet.
Any help on this would be appreciated.