I have just encountered this problem for the first time on a
password-protected workbook (originally converted from Excel 2000) where the
macros worked a month ago. Removing the password enabled the macros. I see
there was an update to Office 2007 two weeks ago, which appears to have
introduced the problem, though previous posts are older than this. Perhaps
Microsoft have extended this 'feature' in the recent update?