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"
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.