View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How do you get a macro to run upon opening a SpSheet

Workbook_open wasn't introduced until xl97. xl5 and xl95 used Auto_open and
Auto_close. Before that, the xl4 macro language used Auto_open xl4 macros.

--
Regards,
Tom Ogilvy

"Stephen Rasey" wrote in message
...
I'll be... It is not in the help, but Auto_Open works.

Stephen Rasey

"Kris" wrote in message
...
Hello Kate,

Name your macro Auto_Open

i.e.

Sub Auto_Open()
'your code
End Sub

Hope this helps,

Kris

-----Original Message-----
Hi,

I have a macro already built into the spreadsheet, but I
need to add a code that would make the macro run when

the
spreadsheet is initially opened by the user.

Any ideas???

Thanks.
Kate
.