Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a new XLS from a standard XLS
I have an XLS with macro that I use as a starting template. I want to be able
to create a file for each person based on a data extract I receive from SQL. The problem I am having is that when I write a macro to open the XLS containing macro, it always ask me if I want to disable or enable macro. How can I bypass the dialog box? Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a new XLS from a standard XLS
You need to reduce the Macro security down to "Low". You will need to
do this on all computers you want not to see the message. <Tools<Macro<Security... On the Security Level tab, check the radio button beside "Low" Make sure you read the explination to make sure this will be ok for you. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a new XLS from a standard XLS
Search your Office installation for the selfcert.exe file and use that create
a digital signature for yourself, then sign the macro. Have each user set their macro security to medium and, when prompted the first time, indicate that you are a trusted source. "matelot" wrote: I have an XLS with macro that I use as a starting template. I want to be able to create a file for each person based on a data extract I receive from SQL. The problem I am having is that when I write a macro to open the XLS containing macro, it always ask me if I want to disable or enable macro. How can I bypass the dialog box? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a Standard Footer | Excel Discussion (Misc queries) | |||
How do I create a bell graph for standard deviation? | Charts and Charting in Excel | |||
is there a standard formula for this? | Excel Worksheet Functions | |||
Can I create a add-in in Visual Basic.net Standard 2003? | Excel Programming | |||
Is there a way to create a standard OHLC bar chart in Excel? | Charts and Charting in Excel |