Store Macros in separate Fiel

[Plinkerton]

Hey,

Is there a way I can store my Excel Macros in a separate file. People
here in the office are alarmed when they open up a file and it gives
them a macro warning. (...Meanwhile, about 50% of them are running
Spyware that promises them big savings)

 

[Guest]

Not tested this but try saving your workbook as an addin File + Save As
{select .XLA format) and then open excel & checkin your addin. I think this
avoids the macro warning. (Don't know about Trusted Sources, though!)

 

[Plinkerton]

Thanks, but I'm afraid the XLA trips it too.

I suppose I could write my code in another XLS, or VB project, and
manipulate the file in a set location. ...That would probably do the
trick.