Run procedure any time ANY workbook is opened

[davegugg]

Hi

Is it possible to run a macro whenever any workbook is opened. I'm think something that uses Personal.xls or an Add-In, but I'm not sure how to use a workbook_open event with those two options that will trigger whenever a new workbook is opened.

Thank You

[Bob Phillips]

Please Login or Register  to view this content.

This is workbook event code.
To input this code, right click on the Excel icon on the worksheet
(or next to the File menu if you maximise your workbooks),
select View Code from the menu, and paste the code

[davegugg]

Thank You, that works great. However, what I'm doing is trying to create an "update links" prompt as in 03. I don't want the prompt to appear if the workbook contains no links or is the Personal.xlsb workbook. I tried coding with activeworkbook.name and activeworkbook.linksources but the code seems to execute before there is an activeworkbook, resulting in an error. Do you know of a workaround?

Edit: Also, why when I close excel does the application remain open but the workbook closes? I want to close the entire application.

[davegugg]

Searched around and for some reason, checking (Show all windows in the Taskbar) under Advanced Excel Options fixed both issue I mentioned above. Excel 07 you crazy sob.

Thanks again Bob Philips