Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a command to 'Hide' the Activeworkbook?
My application consists of two workbooks; one is a menu with a user
form with numerous controls. These controls trigger the contents of, and open the second workbook which includes the finished report. On this report these is a button that enable the user to return to the menu to make new selections. The code behind this is: Sub ReOpenUF3() Application.DisplayAlerts = False ActiveWorkbook.Close UF3.LB1.Visible = False UF3.CB7.Visible = True UF3.TB2.Visible = True UF3.TB2.Value = Sheets("report").Range("XOProd") UF3.Show End Sub The workbook containing the report is large and takes awhile to open. Rather than closing and re-opening this workbook is there a command, or code, to 'hide' the workbook when the user returns to the menu so they don't have to wait for it to 'open'? I tried 'hide' and 'visible = false' but neither work. Thank you, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a command to 'Hide' the Activeworkbook?
hi
visible should have worked. windows("Book2").visible = false or activewindow.visible = false =true to unhide. works in xp, on friday. (you know how mondays can be.) regards FSt1 "Tony Bender" wrote: My application consists of two workbooks; one is a menu with a user form with numerous controls. These controls trigger the contents of, and open the second workbook which includes the finished report. On this report these is a button that enable the user to return to the menu to make new selections. The code behind this is: Sub ReOpenUF3() Application.DisplayAlerts = False ActiveWorkbook.Close UF3.LB1.Visible = False UF3.CB7.Visible = True UF3.TB2.Visible = True UF3.TB2.Value = Sheets("report").Range("XOProd") UF3.Show End Sub The workbook containing the report is large and takes awhile to open. Rather than closing and re-opening this workbook is there a command, or code, to 'hide' the workbook when the user returns to the menu so they don't have to wait for it to 'open'? I tried 'hide' and 'visible = false' but neither work. Thank you, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Command button - still use it | Excel Programming | |||
Hide Command Shell window | Excel Programming | |||
Hide command button | Excel Programming | |||
How do I hide 5 command buttons | Excel Programming | |||
Hide Row command using if statement | Excel Worksheet Functions |