Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Try
ActiveWindow.Visible = False That will hide the active workbook window, but Excel and its toolbar (etc.) with stay visible. You'll just have a gray background, o whatever your color is in windows. Note: I'm not sure how hiding the window will affect your access to i from within VBA, but it may have to be unhidden and hidden to mak changes to any cells. It you're using the application.screenupdating false, you should fine as long as it's appropriately placed in th code. -Gitcyphe -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I restore excel running in the background? | Excel Discussion (Misc queries) | |||
"clean up" after running a program in Excel | Excel Worksheet Functions | |||
running macro at the background | Excel Programming | |||
onTime loop running in the background | Excel Programming | |||
Running Excel as a batch job AND in the background | Excel Programming |