Need to know a workbook is just open
 

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

Need to know a workbook is just open
 

see this page

http://www.cpearson.com/excel/AppEvent.htm

ben

--
When you lose your mind, you free your life.


"Who I Am" wrote:

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