Gibson Research Corporation (www.GRC.com) recently designed and released a highly secure, zero-cost, freely available “One Time Password” system for providing multi-factor authentication – similar to the hardware “tokens” we’ve discussed before – but requiring NO hardware. It’s known as “Perfect Paper Passwords” and has now been implemented in all popular programming languages. It is being used by end-users to access their PCs, by web sites, by private corporations, and many others:
Leo and I will describe the design and operation of this freely available, open source, super-secure solution which will likely see increasing use in the future.
RELATED WEBSITE LINKS
http://www.GRC.com/ppp.htm
• From Word, PowerPoint or Excel 2007, Choose Insert – SmartArt
• Choose one of the layouts (this can be changed later)
• Build your message in the text pane. Excel automatically resizes the text in the graphic to fit and keep all shapes balanced.
• Choose a color scheme.
• Choose an effect from the five 2-D styles or 7 3-D styles. Note the last style is great for sharing bad news (no one can read anything)
• Show how easy to present the same message in new shapes by changing to a new layout.
• Show off a gallery of 8–10 SmartArt layouts
The amazing tip that Microsoft doesn’t tell anyone:
• Normally, values in the shapes can not come from formulas in Excel. I published the workaround that allows this to happen:
• Create the SmartArt with dummy text.
• Select one shape in the diagram.
• Press Ctrl+A to select all shapes.
• In a blank section of the worksheet, paste a copy of the SmartArt. But – it is no longer SmartArt – it is now a collection of Excel shapes!
• Select a shape. Click in the Formula bar. Type =A1 and press Enter. The value in the shape now comes from cell A1.
• Repeat for each shape.
Now, when the formulas in the spreadsheet change, the text in the SmartArt will change.
I will post show notes at http://www.mrexcel.com/tip155.shtml