View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
John Wilson John Wilson is offline
external usenet poster
 
Posts: 550
Default Forcing users to enable macros

Ed,

As the workbook is saved with that one worksheet visible, I really
don't think that there's a way to not have it display before your
code starts running.

John

"universal" wrote in message
...
Ive now tried application.visible = false as the first command in
workbook_open. Still the reminder flashes up for (allbeit) probably a
tenth of a second.

Is there any way I can add a delay in somewhere to give Excel chance to
run more lines before displaying anything at all?


---
Message posted from http://www.ExcelForum.com/