How can I minimize the excell while writting into it?

[chandan]

Hi,
I am try to write in Excel,Problem is that while writing on excel
having large content ,Excel file is visible and when I click on that
excel file , writing process crashes on excell having some exception.

I want that while writting that excel file shoul be disable or in
minimize state.So that user cannot able to do any thing until the
writting process completed.I try to find the solution to mimimize the
excel file while writting but didnot get any function.

Let me know if any such funtion are availble,also some link for
tutorial on this topic.

Thansk,
Chandan kumar

 

[Jan Hyde (VB MVP)]

To minimise Excel

Application.WindowState = xlMinimized

However, the user could just restore it.



chandan <[email protected]>'s wild thoughts were released

 

[chandan]

Thanks Jan,

With Regards,
Chandan kumar

To minimise Excel

        Application.WindowState = xlMinimized

However, the user could just restore it.

chandan <[email protected]>'s wild thoughts were released

 

[Karl E. Peterson]

To minimise Excel

Application.WindowState = xlMinimized

However, the user could just restore it.

Go nuclear - use Application.Visible instead. <eg>