View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Stephen Rasey[_2_] Stephen Rasey[_2_] is offline
external usenet poster
 
Posts: 41
Default How do you get a macro to run upon opening a SpSheet

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
.