View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Chuckles123[_86_] Chuckles123[_86_] is offline
external usenet poster
 
Posts: 1
Default NEXT LEVEL OF ScreenUpdating


Rich,

I inserted a MsgBox before the first line of executable code. The
macro is named 'Auto_Open()' and is triggered via a Windows' Scheduled
Task. The grey box appears when the MsgBox does (actually, the user
has to click on the application button in the XP Taskbar); the result
is the same when inserting 'Applicatiion.ScreenUpdating = False' before
the MsgBox.

In my .xlA macro file, I have VBA code but the Excel counterpart of my
code is a grey window. I guess I could export each of my 10 modules
into a blank workbook, store it as an .xlS file (not sure if that makes
any difference), and most importantly, make sure that the Excel
counterpart has gridlines.

Any comments?

Chuckles123


--
Chuckles123
------------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948
View this thread: http://www.excelforum.com/showthread...hreadid=385041