Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Where to store macros? | Excel Discussion (Misc queries) | |||
USING AN .xla FILE TO STORE MACROS | Excel Programming | |||
USING AN .xla FILE TO STORE MACROS | Excel Programming | |||
How to store organization wide macros? | Excel Programming | |||
Where to store standard macros | Excel Programming |