Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
always on top
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
always on top
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/...p_HT_Chart.asp FORUM: http://www.msofficegurus.com/forum/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
always on top
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|