Your security settings are most unwise. You should not use 'Enable all macros' and you should not check the 'Trust access ..' option. With those settings, a macro virus could do a lot of damage to your system.

As for your problems with xls files only, that suggests there may be a problem with your Office installation. Try repairing the Office installation (via Excel Options|Resources|Diagnose).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you for the idea
MS Office Diagnostics has solved my problem.
Workbook_Open() event is now working

Thanks for Your answers