Hi, I have 2 questions. The first is that I have a program that has
Userform that make use of the same array (A public array declared o
module 1).

Now what I do is I fill the array with data everytime the workbook i
opened but for some reason when I happen to be debugging and I stop i
the middle of the debugger the array seems to empty completelly and
have to rerun the Workbook_Open() procedure. My question is if there i
anyway to keep this array filled at all times (As long as the book i
opened that is)?

Another question is if one can run a macro from another workbook (O
say a Procedure) and if so how?

Best Regards

Noo

--
Message posted from http://www.ExcelForum.com