Excel 2007 Security Oddity Posted
I've received several emails from people asking about the security warnings in Excel 2007. Sometimes they see the warning above the formula bar (shown here); other times the warning comes in the form of a dialog box.
It seemed odd to me too, but I eventually figured it out and posted the answer to the puzzle. See: Two Types of Security Warnings in Excel 2007.
* * *
And speaking of annoyances. If you open a file and get the security warning shown above, the natural inclination is to press Alt+F11 and check out the code. But if you do that you lose the opportunity to enable the macros. So if the macros check out OK, you need to re-open the file. That scenario has happened to me at least 30 times.
Spreadsheet Page Blog
Welcome to the Spreadsheet Page Blog. This is where you find the latest news on my books, add-ins, and other Excel-related topics. Comments are welcome.