We use a sophiscated program to munipulate data. At some points during
the munnipulation process, if we click a button, we get a Excel
spreadsheet from which we get certain information.

My question is how a macro that resides in my Personal.xls knows that a
workbook is open?

What I need is that after the book is open, my macro will do something
in it, like adjust column width, etc.

Thanks

HZ