Hi,

i wrote a function into a module and when i start my excel document, i
display a form.
this form allow me to perform some actions, especially to run a function.
when this function is executed, i want to hide my main form and display
progression of my function calculation on another form.
this second form should just display a progress bar and display a message
progression text like "150 records done over 40000..."

questions are :
1. how can i display on the excel document opening, my main form ?
2. how can i force user to have only access to the main form and not to
excel menu itself ?
3. how to actualize my 2nd form (progression form) with the progression bar
and the text ? usually excel doesn't update it and seems to be frozen, but
behind this it works normally but use 100% of CPU.

thanks a lot,

Maileen