Auto_open

[dan]

When I open a workbook with macros, a msgbox "if I want to enable the
Macros" appeared.
Is there a script for Auto_open() to enable by default.
Thanks

[tim m]

That message is probably relateing to the macro security settings you have
for Excel. Tools...options....security...macro security

Depending on what setting you have this set to it will deny all macros, or
ask if you want to trust the macros (medium) or open without asking. (This
one is not recommended unless you are 100% sure you can trust the source)

"dan" wrote:

> When I open a workbook with macros, a msgbox "if I want to enable the
> Macros" appeared.
> Is there a script for Auto_open() to enable by default.
> Thanks
>
>
>

[dan]

Thank you Tim,
Can I exclusively apply it to my own books instead of globly?

"tim m" <timm@discussions.microsoft.com> wrote in message
news:145FEE5A-9E67-439F-A9B7-F7EE9307F3C6@microsoft.com...
> That message is probably relateing to the macro security settings you have
> for Excel. Tools...options....security...macro security
>
> Depending on what setting you have this set to it will deny all macros, or
> ask if you want to trust the macros (medium) or open without asking. (This
> one is not recommended unless you are 100% sure you can trust the source)
>
> "dan" wrote:
>
>> When I open a workbook with macros, a msgbox "if I want to enable the
>> Macros" appeared.
>> Is there a script for Auto_open() to enable by default.
>> Thanks
>>
>>
>>

[Harald Staff]

You can sign your macros with a digital signature -do a google on
"selfcert.exe" or post back if you cant find anything on it.

Now set security to Medium -the only reasonable security level in my
opinion. On opening of your signed file Excel will ask "This workbook
contains macros by John Smith (or whatever your little name is)" and if you
click "Always trust this source" then your signed macros will open without
asking from now on.

HTH. Best wishes Harald

"dan" <danchen5@verizon.net> skrev i melding
news:%jvbg.232$PX3.180@trndny09...
> Thank you Tim,
> Can I exclusively apply it to my own books instead of globly?
>
> "tim m" <timm@discussions.microsoft.com> wrote in message
> news:145FEE5A-9E67-439F-A9B7-F7EE9307F3C6@microsoft.com...
> > That message is probably relateing to the macro security settings you
have
> > for Excel. Tools...options....security...macro security
> >
> > Depending on what setting you have this set to it will deny all macros,
or
> > ask if you want to trust the macros (medium) or open without asking.
(This
> > one is not recommended unless you are 100% sure you can trust the
source)
> >
> > "dan" wrote:
> >
> >> When I open a workbook with macros, a msgbox "if I want to enable the
> >> Macros" appeared.
> >> Is there a script for Auto_open() to enable by default.
> >> Thanks
> >>
> >>
> >>
>
>

[Ardus Petus]

On my box (Office 2000 - default installation), SelfCert.exe is in:
C:\Program Files\Microsoft Office\Office

HTH
--
AP

"Harald Staff" <innocent@enron.invalid> a écrit dans le message de news:
eg8rBT$eGHA.1264@TK2MSFTNGP05.phx.gbl...
> You can sign your macros with a digital signature -do a google on
> "selfcert.exe" or post back if you cant find anything on it.
>
> Now set security to Medium -the only reasonable security level in my
> opinion. On opening of your signed file Excel will ask "This workbook
> contains macros by John Smith (or whatever your little name is)" and if
> you
> click "Always trust this source" then your signed macros will open without
> asking from now on.
>
> HTH. Best wishes Harald
>
> "dan" <danchen5@verizon.net> skrev i melding
> news:%jvbg.232$PX3.180@trndny09...
>> Thank you Tim,
>> Can I exclusively apply it to my own books instead of globly?
>>
>> "tim m" <timm@discussions.microsoft.com> wrote in message
>> news:145FEE5A-9E67-439F-A9B7-F7EE9307F3C6@microsoft.com...
>> > That message is probably relateing to the macro security settings you
> have
>> > for Excel. Tools...options....security...macro security
>> >
>> > Depending on what setting you have this set to it will deny all macros,
> or
>> > ask if you want to trust the macros (medium) or open without asking.
> (This
>> > one is not recommended unless you are 100% sure you can trust the
> source)
>> >
>> > "dan" wrote:
>> >
>> >> When I open a workbook with macros, a msgbox "if I want to enable the
>> >> Macros" appeared.
>> >> Is there a script for Auto_open() to enable by default.
>> >> Thanks
>> >>
>> >>
>> >>
>>
>>
>
>

[dan]

You are so helpful.
FYI, In XP SelfCert.exe is in:
C:\Program Files\Microsoft Office\Office10
Thanks

"Ardus Petus" <ardus.petus@laposte.net> wrote in message
news:e6IDVa$eGHA.2188@TK2MSFTNGP04.phx.gbl...
> On my box (Office 2000 - default installation), SelfCert.exe is in:
> C:\Program Files\Microsoft Office\Office
>
> HTH
> --
> AP
>
> "Harald Staff" <innocent@enron.invalid> a écrit dans le message de news:
> eg8rBT$eGHA.1264@TK2MSFTNGP05.phx.gbl...
>> You can sign your macros with a digital signature -do a google on
>> "selfcert.exe" or post back if you cant find anything on it.
>>
>> Now set security to Medium -the only reasonable security level in my
>> opinion. On opening of your signed file Excel will ask "This workbook
>> contains macros by John Smith (or whatever your little name is)" and if
>> you
>> click "Always trust this source" then your signed macros will open
>> without
>> asking from now on.
>>
>> HTH. Best wishes Harald
>>
>> "dan" <danchen5@verizon.net> skrev i melding
>> news:%jvbg.232$PX3.180@trndny09...
>>> Thank you Tim,
>>> Can I exclusively apply it to my own books instead of globly?
>>>
>>> "tim m" <timm@discussions.microsoft.com> wrote in message
>>> news:145FEE5A-9E67-439F-A9B7-F7EE9307F3C6@microsoft.com...
>>> > That message is probably relateing to the macro security settings you
>> have
>>> > for Excel. Tools...options....security...macro security
>>> >
>>> > Depending on what setting you have this set to it will deny all
>>> > macros,
>> or
>>> > ask if you want to trust the macros (medium) or open without asking.
>> (This
>>> > one is not recommended unless you are 100% sure you can trust the
>> source)
>>> >
>>> > "dan" wrote:
>>> >
>>> >> When I open a workbook with macros, a msgbox "if I want to enable the
>>> >> Macros" appeared.
>>> >> Is there a script for Auto_open() to enable by default.
>>> >> Thanks
>>> >>
>>> >>
>>> >>
>>>
>>>
>>
>>
>
>

[dan]

Thank you Harald, I had it working.

"Harald Staff" <innocent@enron.invalid> wrote in message
news:eg8rBT$eGHA.1264@TK2MSFTNGP05.phx.gbl...
> You can sign your macros with a digital signature -do a google on
> "selfcert.exe" or post back if you cant find anything on it.
>
> Now set security to Medium -the only reasonable security level in my
> opinion. On opening of your signed file Excel will ask "This workbook
> contains macros by John Smith (or whatever your little name is)" and if
> you
> click "Always trust this source" then your signed macros will open without
> asking from now on.
>
> HTH. Best wishes Harald
>
> "dan" <danchen5@verizon.net> skrev i melding
> news:%jvbg.232$PX3.180@trndny09...
>> Thank you Tim,
>> Can I exclusively apply it to my own books instead of globly?
>>
>> "tim m" <timm@discussions.microsoft.com> wrote in message
>> news:145FEE5A-9E67-439F-A9B7-F7EE9307F3C6@microsoft.com...
>> > That message is probably relateing to the macro security settings you
> have
>> > for Excel. Tools...options....security...macro security
>> >
>> > Depending on what setting you have this set to it will deny all macros,
> or
>> > ask if you want to trust the macros (medium) or open without asking.
> (This
>> > one is not recommended unless you are 100% sure you can trust the
> source)
>> >
>> > "dan" wrote:
>> >
>> >> When I open a workbook with macros, a msgbox "if I want to enable the
>> >> Macros" appeared.
>> >> Is there a script for Auto_open() to enable by default.
>> >> Thanks
>> >>
>> >>
>> >>
>>
>>
>
>

[Harald Staff]

Good for you.
I should mention that I've had some serious problems with digitally signed
files when I've worked with multiple versions of Excel simoultaneously (I've
had Excel 2000 and Excel 2003 upå and running at the same time on the same
computer). This will not be a problem for "normal" users, so this warning is
just for the record.

Best wishes Harald

"dan" <danchen5@verizon.net> skrev i melding
news:9UIbg.701$JL5.230@trndny03...
> Thank you Harald, I had it working.
>
> "Harald Staff" <innocent@enron.invalid> wrote in message
> news:eg8rBT$eGHA.1264@TK2MSFTNGP05.phx.gbl...
> > You can sign your macros with a digital signature -do a google on
> > "selfcert.exe" or post back if you cant find anything on it.