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
.
|