I have a little problem with Excel - some steps outside my base-competency ...
I want to do some action if the Excel-Workbook opens. I found that the Workbook_Open-method (declared inside the Workbook-script) is responsible for this.
If I save my file in Excel97-Format as xyz.XLS it works properly.
But if I save it als xyz.XLSM (I use Excel 2010) this Event isn't raised - independand of what I'm doing inside the method. Every other Event-Method (inside the Workbook or a table) is working properly.
So ... where is my mistake ?
Or should I change a Property anywhere to another value ?
What I have tried:
Searching in Internet, severall tries ... ask a question here ... :)