Two Types Of Security Warnings In Excel 2007
If you use Excel 2007, you might have noticed that Excel provides you with two different macro warning notices.
Sometimes, you'll open a file and see this message above the formula bar:
Other times, you'll get this dialog box instead:
It took me a long time to figure out what's going on. As it turns out, if you have the Visual Basic Editor window open, you'll get the dialog box warning. If the VB Editor is not open, you'll get the warning in the worksheet.
Excel is a complex program, and has been around for a long time. Consequently, it has many obscure nooks and crannies to discover. Some of them are described here.
Keep in mind that some versions of Excel are odder than others. In other words, the things described here may not apply to all versions of Excel.
All Odd Stuff
Browse Oddities by Category
Seen Something Odd?
If you've discovered something weird about Excel, let me know.