I have an Add-in which needs to call a Sub for each workbook opened.
The problem is that it's only called up when Excel starts on the first instance.
If I open or start Excel again (while the first is open), it doesn't trigger the Workbook_Open event.
Is there something else which will work?
Why is the code not in the addin?
That doesn't answer my question Why can't the code be in the addin?
Also, you must have something wrong with the code because Chip's code works. Attach a example of your addin and the a sample workbook that you want it to work with.
Yes it's in the Addin as per question.
The code in the link does work and as I said in the question, mine doesn't.
I'm just trying to say that it now works.
So the problem is solved?
Yes it is thank you.
Don’t have an account yet? Register yourself now and be a part of our community!