View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
gitcypher[_16_] gitcypher[_16_] is offline
external usenet poster
 
Posts: 1
Default Clean Up Background While Running Macro

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