ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Store Macros in separate Fiel (https://www.excelbanter.com/excel-programming/324408-store-macros-separate-fiel.html)

Plinkerton

Store Macros in separate Fiel
 
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)


AA2e72E

Store Macros in separate Fiel
 
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" wrote:

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)



Plinkerton

Store Macros in separate Fiel
 
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.



All times are GMT +1. The time now is 12:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com