Thread: how to add a sub at the application level open event?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default how to add a sub at the application level open event?
Put the workbook open macro in your personal.xls file.
--
Gary''s Student - gsnu200751


"Rich" wrote:

Greetings,

How do I add a subroutine at the application level?

Example: When I start up Excel I want to have it bring up a messagebox that
says "test"

I can see in the VB editor how to do this at the workbook level in the
workbook open event. But I need to do this at the application level.

Thanks.
Rich
Reply With QuoteReply With Quote