.visible command

[scrappe7]

I have a rather detailed macro that opens a lot of xls files then closes them. Id rather the user not see all the processing and only see the end result. I tried using Application.Visible = Flase at the begining and then Application.Visible = True as the last line to bring excel back on the screen but this does not do the trick. IS there a way to hide just the workbooks being opened and closed and ntot he entire excel application?

 

[SkipVought]

Hi,
Try using...

Application.ScreenUpdating = False
'stuff happens
Application.ScreenUpdating = True
'get out

That will "freeze" everything while the application runs. You might want to let the user know that something good is happening -- maybe by statusing the progress on the StatusBar. Skip,
metzgsk@voughtaircraft.com

 

[scrappe7]

How would I throw a status bar in there, youre thing worked perfectly, thanks.

 

[SkipVought]

The StatusBar object is displayed in the bottom margin of your Excel window. It probably displays "Ready" if you were to look at it now.

Use the Help menu to see how the Statusbar Object is formatted. It is a good practice to dim an OldStatusbar to store the attributes of the Statusbar before you change it, and then return the attributes after you're done. But the short of it is that you can assign values to the statusbar very simply...

Application.StatusBar = MyStatusMessage

Hope this helps. Skip,
metzgsk@voughtaircraft.com

 

[scrappe7]

Thanks for the tip tekky