I am looking to add a function to a number of workbooks that are used for tracking compliance. I would like excel, on open, to look into a dormant workbook and check a column of data. If a yes exist then a msgbox deploys with the pertinent warning.
I am not certain exactly how to have excel...