I understand about macro security settings and I have mine set to "Medium", so when I open a workbook I should be asked whether I want macros enabled or not.
However, this only happens when I open a file from Explorer or from the recently-used list under File (in Excel itself). If I use File, Open and browse for the file, Excel opens it and enables macros without asking, but ignores any Auto_Open macro.
I used to think that this was a quirk of my PC, but I have since noticed that the same thing happens for a lot of my colleagues. The worry is that some of my most widely-used workbooks rely on an Auto_Open macro to set various values and protect worksheets, etc.
Has anybody come across this and is there a way of ensuring the Auto_Open macros run?