Run code when ANY file opens
It only runs when the addin gets loaded - it has nothing to do with any other
file being opened. So the short answer is no.
--
Regards,
Tom Ogilvy
"Shimmess" wrote:
Will this work then on a file that is opened and excel is already running?
"moon" wrote:
In a module, create an Auto_Open macro, like:
Public Sub Auto_Open()
'do the hokie pokie
End Sub
Save your file with the .xla extension, to make it an Add-in.
Pick Extra/Add-ins and check your own file. After that, it'll always run
when Excel is opened.
"Shimmess" schreef in bericht
...
I want to run some VBA code on a PC whenever ANY workbook is opened in
excel.
It can not only be when excel opens, it need to be even if a new file is
oened once excel is already running. Any suggestions?
|