View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John[_62_] John[_62_] is offline
external usenet poster
 
Posts: 16
Default Macro doesn't start up

Hi all,
I wrote a simple code 'msgbox "workbook open"' and placed
it in workbook_open() and workbook_activate() events. I
saved and closed it as .xls. When I opened it again, the
message doesn't comes up.

I tried that with other files and it seems to work. Does
any one have any ideas/suggestions why this certain file
doesn't seem to run the macro at start up. I know that
open up a template won't activate the open() or activate
() events, but this is not a template file.

Thanks for any suggestions.

John.