Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
display in excel stays blank
Okay,
I am running several macro's in excel. While these macro's ar running,spreadsheets are continually appearing on the screen (eithe being opened, or coming to the front of the other pages). I don't wan this to happen. I would like to have a blank display while my marco' are running. I am not sure how to do this. If you could send me som code, or help me out in some way that would be great. Thank -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
display in excel stays blank
I dont know how to display a blank sheet except perhaps you should add
sheet call it some name like "hidden" then hide it then you can call i and hide it after your events something like this Worksheets("hidden").Visible = True Worksheets("hidden").Select With Application .EnableEvents = False .ScreenUpdating = False End With Worksheets("hidden").Visible = False Put the last line before your end sub of your code, and the rest at th begining of your code. I'm fairly new to this so it may take some tweaking, there are loads o clever people on here who an give you a hand if that doesnt wor properly! HTH Simo -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
display in excel stays blank
Application.ScreenUpdating = False ''do your stuff Application.ScreenUpdating = True Gord Dibben Excel MVP On Wed, 23 Jun 2004 16:40:39 -0500, calculus87 wrote: Okay, I am running several macro's in excel. While these macro's are running,spreadsheets are continually appearing on the screen (either being opened, or coming to the front of the other pages). I don't want this to happen. I would like to have a blank display while my marco's are running. I am not sure how to do this. If you could send me some code, or help me out in some way that would be great. Thanks --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
display in excel stays blank
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
Excel says ready but blue Blank Screen stays on and file doesn't o | Excel Discussion (Misc queries) | |||
how to get excel to display blank if reference cell blank | Excel Worksheet Functions | |||
display negative values as a blank cell in Excel | Excel Discussion (Misc queries) | |||
display negative values as a blank cell in Excel | Excel Discussion (Misc queries) |