![]() |
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) |
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) |
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