always on top

[PBcorn]

I have a macro which opens and merges various workbooks from a button on
another workbook. I want to keep the workbook with the button displayed at
all times while the macro runs, and not display the merging workbooks. Ideas
please.

 

[Robert Martim, Excel]

You can change the visibility of the other workbooks. You set the workbook
and then make it invisible:

Set oWorkbook = Application.Workbooks("My_Workbook_Name")
Application.Windows(oWorkbook.Name).Visible = False

--
Robert
Author of RibbonX: Customizing the Office 2007 Ribbon:
LATEST INTERACTIVE TUTORIAL:
http://www.msofficegurus.com/videos/StepByStep_HT_Chart.asp
FORUM: http://www.msofficegurus.com/forum/

 

[Jim Cone]

Perhaps, setting "Application.ScreenUpdating" to False before opening
the other workbooks.
Also, setting "Application.ShowWindowsInTaskbar" to False will prevent
the workbook buttons from appearing in the taskbar at the bottom of the window.
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"PBcorn" <[email protected]>
wrote in message
I have a macro which opens and merges various workbooks from a button on
another workbook. I want to keep the workbook with the button displayed at
all times while the macro runs, and not display the merging workbooks. Ideas
please.