| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide the spreadsheet
I was wondering if it would be possible to hide the normal excel window
while a macro was running. Thanks - David |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide the spreadsheet
Application.Visible = False
or Sub ABC() Application.WindowState = xlMinimized For i = 1 To 10000000 j = j + 1 Next Application.WindowState = xlNormal End Sub if you are doing a lot of selecting just try using Application.ScreenUpdating = False Sub MyExistingSub() Application.Screenupdating = False ' current commands Application.Screenupdating = True End Sub -- Regards, Tom Ogilvy "David" wrote in message ps.com... I was wondering if it would be possible to hide the normal excel window while a macro was running. Thanks - David |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide the spreadsheet
Tom, that would be
i = i + 1 This creates a kind of 'Wait' command adjusting the length of time with the number. Mike F "Tom Ogilvy" wrote in message ... Application.Visible = False or Sub ABC() Application.WindowState = xlMinimized For i = 1 To 10000000 j = j + 1 Next Application.WindowState = xlNormal End Sub if you are doing a lot of selecting just try using Application.ScreenUpdating = False Sub MyExistingSub() Application.Screenupdating = False ' current commands Application.Screenupdating = True End Sub -- Regards, Tom Ogilvy "David" wrote in message ps.com... I was wondering if it would be possible to hide the normal excel window while a macro was running. Thanks - David |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide the spreadsheet
No on the correction, i is adjusted by the FOR loop
adding to j was some dummy work - yes, it is just to cause a delay. It was for demonstration purposes only. -- Regards, Tom Ogilvy "Mike Fogleman" wrote in message m... Tom, that would be i = i + 1 This creates a kind of 'Wait' command adjusting the length of time with the number. Mike F "Tom Ogilvy" wrote in message ... Application.Visible = False or Sub ABC() Application.WindowState = xlMinimized For i = 1 To 10000000 j = j + 1 Next Application.WindowState = xlNormal End Sub if you are doing a lot of selecting just try using Application.ScreenUpdating = False Sub MyExistingSub() Application.Screenupdating = False ' current commands Application.Screenupdating = True End Sub -- Regards, Tom Ogilvy "David" wrote in message ps.com... I was wondering if it would be possible to hide the normal excel window while a macro was running. Thanks - David |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide the spreadsheet
Thanks Tom that worked great. Also is there any way to run a macro when
excel first starts instead of having to have the user click run. Thanks. - David Tom Ogilvy wrote: No on the correction, i is adjusted by the FOR loop adding to j was some dummy work - yes, it is just to cause a delay. It was for demonstration purposes only. -- Regards, Tom Ogilvy "Mike Fogleman" wrote in message m... Tom, that would be i = i + 1 This creates a kind of 'Wait' command adjusting the length of time with the number. Mike F "Tom Ogilvy" wrote in message ... Application.Visible = False or Sub ABC() Application.WindowState = xlMinimized For i = 1 To 10000000 j = j + 1 Next Application.WindowState = xlNormal End Sub if you are doing a lot of selecting just try using Application.ScreenUpdating = False Sub MyExistingSub() Application.Screenupdating = False ' current commands Application.Screenupdating = True End Sub -- Regards, Tom Ogilvy "David" wrote in message ps.com... I was wondering if it would be possible to hide the normal excel window while a macro was running. Thanks - David |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide the spreadsheet
in the VBE, double click on the Thisworkbook entry in the project explorer
(on the left ) entry for your project. This will bring up the ThisWorkbook code module. in the left dropdown at the top of the module select Workbook, in the right dropdown at the top of the module select Open. This will put in the declaration for the Workbook_Open event which fires when the workbook is opened. Private Sub Workbook_Open() End sub You can add code here or call your macro Private Sub Workbook_Open() MyMacro End sub See Chip Pearson's page on events for a general overview http://www.cpearson.com/excel/events.htm -- Regards, Tom Ogilvy "David" wrote in message oups.com... Thanks Tom that worked great. Also is there any way to run a macro when excel first starts instead of having to have the user click run. Thanks. - David Tom Ogilvy wrote: No on the correction, i is adjusted by the FOR loop adding to j was some dummy work - yes, it is just to cause a delay. It was for demonstration purposes only. -- Regards, Tom Ogilvy "Mike Fogleman" wrote in message m... Tom, that would be i = i + 1 This creates a kind of 'Wait' command adjusting the length of time with the number. Mike F "Tom Ogilvy" wrote in message ... Application.Visible = False or Sub ABC() Application.WindowState = xlMinimized For i = 1 To 10000000 j = j + 1 Next Application.WindowState = xlNormal End Sub if you are doing a lot of selecting just try using Application.ScreenUpdating = False Sub MyExistingSub() Application.Screenupdating = False ' current commands Application.Screenupdating = True End Sub -- Regards, Tom Ogilvy "David" wrote in message ps.com... I was wondering if it would be possible to hide the normal excel window while a macro was running. Thanks - David |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide the spreadsheet
Thanks Tom.
- David Tom Ogilvy wrote: in the VBE, double click on the Thisworkbook entry in the project explorer (on the left ) entry for your project. This will bring up the ThisWorkbook code module. in the left dropdown at the top of the module select Workbook, in the right dropdown at the top of the module select Open. This will put in the declaration for the Workbook_Open event which fires when the workbook is opened. Private Sub Workbook_Open() End sub You can add code here or call your macro Private Sub Workbook_Open() MyMacro End sub See Chip Pearson's page on events for a general overview http://www.cpearson.com/excel/events.htm -- Regards, Tom Ogilvy "David" wrote in message oups.com... Thanks Tom that worked great. Also is there any way to run a macro when excel first starts instead of having to have the user click run. Thanks. - David Tom Ogilvy wrote: No on the correction, i is adjusted by the FOR loop adding to j was some dummy work - yes, it is just to cause a delay. It was for demonstration purposes only. -- Regards, Tom Ogilvy "Mike Fogleman" wrote in message m... Tom, that would be i = i + 1 This creates a kind of 'Wait' command adjusting the length of time with the number. Mike F "Tom Ogilvy" wrote in message ... Application.Visible = False or Sub ABC() Application.WindowState = xlMinimized For i = 1 To 10000000 j = j + 1 Next Application.WindowState = xlNormal End Sub if you are doing a lot of selecting just try using Application.ScreenUpdating = False Sub MyExistingSub() Application.Screenupdating = False ' current commands Application.Screenupdating = True End Sub -- Regards, Tom Ogilvy "David" wrote in message ps.com... I was wondering if it would be possible to hide the normal excel window while a macro was running. Thanks - David |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to hide 0.00 on spreadsheet with formula? | Excel Worksheet Functions | |||
| hide row on spreadsheet | Excel Discussion (Misc queries) | |||
| Want to Hide columns in spreadsheet but NOT hide data in chart. | Charts and Charting in Excel | |||
| How do I hide a formula so it will not show on the spreadsheet? | Excel Worksheet Functions | |||
| how do you hide the #DIV/0! in a blank spreadsheet? | Excel Discussion (Misc queries) | |||
Linear Mode
