Security Warning for Add in in EXCEL and WORD 2007

[Digambar]

Hi All,

We have a toolbar developed in VBA which loads successfully whenever Word
and Excel(Office 2003) are started.

However when i tried it on Office 2007 Beta2 it's giving a securtiy warning
like Macro not certified. When i add the path from where it loads to Trusted
Location(Option,Trust Center,Trusted Location) i don't get the warning.

I would like to know how i can avoid this. Also i would be happy to know if
there is anything to automate these steps involved(i,e Option,Trust
Center,Trusted Location).

Regards,
Digambar.

 

[Patrick Schmid [MVP]]

You would have to get a digital certificate to avoid this problem. Or,
if you are in a corporate scenario, set the trusted locations via group
policies.
By the way, you really should not be using a beta version anymore for
development. The final version of Office 2007 has been available for
quite some time now.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

 

[XL-Dennis]

Patrick - You're right ! I thought .NET but didn't quite understand that it
was VBA.

A certificate at Thawte cost abour USD 200 / year and at VeriSign USD 400 /
year. However, the yearly fee is to renew the rights to use the certificate
and has nothing to do with any already digital signed VBA-solutions.

It takes some time to obtain the certificate as there exist a control
process (including to provide wanted documentations and also some phone
calls).

It also take some time to set it up propertly on a developing machine.

---------------
With kind regards,
Dennis
Weekly Blog .NET & Excel: http://xldennis.wordpress.com/
My English site: http://www.excelkb.com/default.aspx
My Swedish site: http://www.xldennis.com/

 

[Digambar]

You would have to get a digital certificate to avoid this problem. Or,
if you are in a corporate scenario, set the trusted locations via group
policies.
By the way, you really should not be using a beta version anymore for
development. The final version of Office 2007 has been available for
quite some time now.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

Hi All,

We have a toolbar developed in VBA which loads successfully whenever Word
and Excel(Office 2003) are started.

However when i tried it on Office 2007 Beta2 it's giving a securtiy warning
like Macro not certified. When i add the path from where it loads to Trusted
Location(Option,Trust Center,Trusted Location) i don't get the warning.

I would like to know how i can avoid this. Also i would be happy to know if
there is anything to automate these steps involved(i,e Option,Trust
Center,Trusted Location).

Regards,
Digambar.

Hi Patrick,

Thanks for your valuable advice.

In the beta version i had added the location path of the toolbar in the
trusted location (excel option, Trust Center,Trusted Location). Is it same as
what you r refering to as trusted locations via group policies.

If not please let me know how do i achieve the same.

Regards,
Digambar

 

[Patrick Schmid [MVP]]

It's the same.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

You would have to get a digital certificate to avoid this problem. Or,
if you are in a corporate scenario, set the trusted locations via group
policies.
By the way, you really should not be using a beta version anymore for
development. The final version of Office 2007 has been available for
quite some time now.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

Hi All,

We have a toolbar developed in VBA which loads successfully whenever Word
and Excel(Office 2003) are started.

However when i tried it on Office 2007 Beta2 it's giving a securtiy warning
like Macro not certified. When i add the path from where it loads to Trusted
Location(Option,Trust Center,Trusted Location) i don't get the warning.

I would like to know how i can avoid this. Also i would be happy to know if
there is anything to automate these steps involved(i,e Option,Trust
Center,Trusted Location).

Regards,
Digambar.

Hi Patrick,

Thanks for your valuable advice.

In the beta version i had added the location path of the toolbar in the
trusted location (excel option, Trust Center,Trusted Location). Is it same as
what you r refering to as trusted locations via group policies.

If not please let me know how do i achieve the same.

Regards,
Digambar

 

[Digambar]

It's the same.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

You would have to get a digital certificate to avoid this problem. Or,
if you are in a corporate scenario, set the trusted locations via group
policies.
By the way, you really should not be using a beta version anymore for
development. The final version of Office 2007 has been available for
quite some time now.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


Hi All,

We have a toolbar developed in VBA which loads successfully whenever Word
and Excel(Office 2003) are started.

However when i tried it on Office 2007 Beta2 it's giving a securtiy warning
like Macro not certified. When i add the path from where it loads to Trusted
Location(Option,Trust Center,Trusted Location) i don't get the warning.

I would like to know how i can avoid this. Also i would be happy to know if
there is anything to automate these steps involved(i,e Option,Trust
Center,Trusted Location).

Regards,
Digambar.

Hi Patrick,

Thanks for your valuable advice.

In the beta version i had added the location path of the toolbar in the
trusted location (excel option, Trust Center,Trusted Location). Is it same as
what you r refering to as trusted locations via group policies.

If not please let me know how do i achieve the same.

Regards,
Digambar

Hi Patrick,

Is there way to Automate these steps Progrmmatically.

Thanks,
Digambar

 

[Patrick Schmid [MVP]]

You mean as part of your add-in?
No, those are security settings protecting the users from add-ins. Hence
why should you be able to modify them from your add-in?

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

It's the same.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

:

You would have to get a digital certificate to avoid this problem. Or,
if you are in a corporate scenario, set the trusted locations via group
policies.
By the way, you really should not be using a beta version anymore for
development. The final version of Office 2007 has been available for
quite some time now.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


Hi All,

We have a toolbar developed in VBA which loads successfully whenever Word
and Excel(Office 2003) are started.

However when i tried it on Office 2007 Beta2 it's giving a securtiy warning
like Macro not certified. When i add the path from where it loads to Trusted
Location(Option,Trust Center,Trusted Location) i don't get the warning.

I would like to know how i can avoid this. Also i would be happy to know if
there is anything to automate these steps involved(i,e Option,Trust
Center,Trusted Location).

Regards,
Digambar.

Hi Patrick,

Thanks for your valuable advice.

In the beta version i had added the location path of the toolbar in the
trusted location (excel option, Trust Center,Trusted Location). Is it same as
what you r refering to as trusted locations via group policies.

If not please let me know how do i achieve the same.

Regards,
Digambar

Hi Patrick,

Is there way to Automate these steps Progrmmatically.

Thanks,
Digambar

 

[Digambar]

Yes as a part of add -in. Because we don't want the user to do these
steps(Excel option,Trust Center, Trust Location).

If i can automate these steps during the loading the user can directly work
with the add in.

Regards,
Digambar.

You mean as part of your add-in?
No, those are security settings protecting the users from add-ins. Hence
why should you be able to modify them from your add-in?

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

It's the same.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


:

You would have to get a digital certificate to avoid this problem. Or,
if you are in a corporate scenario, set the trusted locations via group
policies.
By the way, you really should not be using a beta version anymore for
development. The final version of Office 2007 has been available for
quite some time now.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


Hi All,

We have a toolbar developed in VBA which loads successfully whenever Word
and Excel(Office 2003) are started.

However when i tried it on Office 2007 Beta2 it's giving a securtiy warning
like Macro not certified. When i add the path from where it loads to Trusted
Location(Option,Trust Center,Trusted Location) i don't get the warning.

I would like to know how i can avoid this. Also i would be happy to know if
there is anything to automate these steps involved(i,e Option,Trust
Center,Trusted Location).

Regards,
Digambar.

Hi Patrick,

Thanks for your valuable advice.

In the beta version i had added the location path of the toolbar in the
trusted location (excel option, Trust Center,Trusted Location). Is it same as
what you r refering to as trusted locations via group policies.

If not please let me know how do i achieve the same.

Regards,
Digambar

Hi Patrick,

Is there way to Automate these steps Progrmmatically.

Thanks,
Digambar

 

[Patrick Schmid [MVP]]

Are these users in a corporate environment or customers of a commercial
add-in?

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

Yes as a part of add -in. Because we don't want the user to do these
steps(Excel option,Trust Center, Trust Location).

If i can automate these steps during the loading the user can directly work
with the add in.

Regards,
Digambar.

You mean as part of your add-in?
No, those are security settings protecting the users from add-ins. Hence
why should you be able to modify them from your add-in?

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

:

It's the same.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


:

You would have to get a digital certificate to avoid this problem. Or,
if you are in a corporate scenario, set the trusted locations via group
policies.
By the way, you really should not be using a beta version anymore for
development. The final version of Office 2007 has been available for
quite some time now.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


Hi All,

We have a toolbar developed in VBA which loads successfully whenever Word
and Excel(Office 2003) are started.

However when i tried it on Office 2007 Beta2 it's giving a securtiy warning
like Macro not certified. When i add the path from where it loads to Trusted
Location(Option,Trust Center,Trusted Location) i don't get the warning.

I would like to know how i can avoid this. Also i would be happy to know if
there is anything to automate these steps involved(i,e Option,Trust
Center,Trusted Location).

Regards,
Digambar.

Hi Patrick,

Thanks for your valuable advice.

In the beta version i had added the location path of the toolbar in the
trusted location (excel option, Trust Center,Trusted Location). Is it same as
what you r refering to as trusted locations via group policies.

If not please let me know how do i achieve the same.

Regards,
Digambar

Hi Patrick,

Is there way to Automate these steps Progrmmatically.

Thanks,
Digambar

 

[Digambar]

Most users are in Corporate Enivronment.

Are these users in a corporate environment or customers of a commercial
add-in?

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

Yes as a part of add -in. Because we don't want the user to do these
steps(Excel option,Trust Center, Trust Location).

If i can automate these steps during the loading the user can directly work
with the add in.

Regards,
Digambar.

You mean as part of your add-in?
No, those are security settings protecting the users from add-ins. Hence
why should you be able to modify them from your add-in?

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


:

It's the same.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


:

You would have to get a digital certificate to avoid this problem. Or,
if you are in a corporate scenario, set the trusted locations via group
policies.
By the way, you really should not be using a beta version anymore for
development. The final version of Office 2007 has been available for
quite some time now.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


Hi All,

We have a toolbar developed in VBA which loads successfully whenever Word
and Excel(Office 2003) are started.

However when i tried it on Office 2007 Beta2 it's giving a securtiy warning
like Macro not certified. When i add the path from where it loads to Trusted
Location(Option,Trust Center,Trusted Location) i don't get the warning.

I would like to know how i can avoid this. Also i would be happy to know if
there is anything to automate these steps involved(i,e Option,Trust
Center,Trusted Location).

Regards,
Digambar.

Hi Patrick,

Thanks for your valuable advice.

In the beta version i had added the location path of the toolbar in the
trusted location (excel option, Trust Center,Trusted Location). Is it same as
what you r refering to as trusted locations via group policies.

If not please let me know how do i achieve the same.

Regards,
Digambar

Hi Patrick,

Is there way to Automate these steps Progrmmatically.

Thanks,
Digambar

 

[Patrick Schmid [MVP]]

Do you control these environments? Meaning, can you push out a group
policy setting to those users?

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

Most users are in Corporate Enivronment.

Are these users in a corporate environment or customers of a commercial
add-in?

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

Yes as a part of add -in. Because we don't want the user to do these
steps(Excel option,Trust Center, Trust Location).

If i can automate these steps during the loading the user can directly work
with the add in.

Regards,
Digambar.

:

You mean as part of your add-in?
No, those are security settings protecting the users from add-ins. Hence
why should you be able to modify them from your add-in?

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


:

It's the same.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


:

You would have to get a digital certificate to avoid this problem. Or,
if you are in a corporate scenario, set the trusted locations via group
policies.
By the way, you really should not be using a beta version anymore for
development. The final version of Office 2007 has been available for
quite some time now.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


Hi All,

We have a toolbar developed in VBA which loads successfully whenever Word
and Excel(Office 2003) are started.

However when i tried it on Office 2007 Beta2 it's giving a securtiy warning
like Macro not certified. When i add the path from where it loads to Trusted
Location(Option,Trust Center,Trusted Location) i don't get the warning.

I would like to know how i can avoid this. Also i would be happy to know if
there is anything to automate these steps involved(i,e Option,Trust
Center,Trusted Location).

Regards,
Digambar.

Hi Patrick,

Thanks for your valuable advice.

In the beta version i had added the location path of the toolbar in the
trusted location (excel option, Trust Center,Trusted Location). Is it same as
what you r refering to as trusted locations via group policies.

If not please let me know how do i achieve the same.

Regards,
Digambar

Hi Patrick,

Is there way to Automate these steps Progrmmatically.

Thanks,
Digambar

 

[Digambar]

No.Basically the add in can be used by anybody

Do you control these environments? Meaning, can you push out a group
policy setting to those users?

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

Most users are in Corporate Enivronment.

Are these users in a corporate environment or customers of a commercial
add-in?

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


Yes as a part of add -in. Because we don't want the user to do these
steps(Excel option,Trust Center, Trust Location).

If i can automate these steps during the loading the user can directly work
with the add in.

Regards,
Digambar.

:

You mean as part of your add-in?
No, those are security settings protecting the users from add-ins. Hence
why should you be able to modify them from your add-in?

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


:

It's the same.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


:

You would have to get a digital certificate to avoid this problem. Or,
if you are in a corporate scenario, set the trusted locations via group
policies.
By the way, you really should not be using a beta version anymore for
development. The final version of Office 2007 has been available for
quite some time now.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


Hi All,

We have a toolbar developed in VBA which loads successfully whenever Word
and Excel(Office 2003) are started.

However when i tried it on Office 2007 Beta2 it's giving a securtiy warning
like Macro not certified. When i add the path from where it loads to Trusted
Location(Option,Trust Center,Trusted Location) i don't get the warning.

I would like to know how i can avoid this. Also i would be happy to know if
there is anything to automate these steps involved(i,e Option,Trust
Center,Trusted Location).

Regards,
Digambar.

Hi Patrick,

Thanks for your valuable advice.

In the beta version i had added the location path of the toolbar in the
trusted location (excel option, Trust Center,Trusted Location). Is it same as
what you r refering to as trusted locations via group policies.

If not please let me know how do i achieve the same.

Regards,
Digambar

Hi Patrick,

Is there way to Automate these steps Progrmmatically.

Thanks,
Digambar

 

[Patrick Schmid [MVP]]

Then you have to get a digital certificate or explain to users in the
documentation how to deal with the issue. Although you might be able to
set the security settings by modifying the registry, you should not do
that for a variety of reasons. First of all, in the new Vista age, the
user might not have the necessary administrative privileges to alter
them. Secondly, those security settings protect the user from you. They
are the users to modify, not yours. Thirdly, if your add-in alters
security settings, corporate administrators will probably be reluctant
to trust your add-in and hence not allow their users to use it.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

No.Basically the add in can be used by anybody

Do you control these environments? Meaning, can you push out a group
policy setting to those users?

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

Most users are in Corporate Enivronment.

:

Are these users in a corporate environment or customers of a commercial
add-in?

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


Yes as a part of add -in. Because we don't want the user to do these
steps(Excel option,Trust Center, Trust Location).

If i can automate these steps during the loading the user can directly work
with the add in.

Regards,
Digambar.

:

You mean as part of your add-in?
No, those are security settings protecting the users from add-ins. Hence
why should you be able to modify them from your add-in?

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


:

It's the same.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


:

You would have to get a digital certificate to avoid this problem. Or,
if you are in a corporate scenario, set the trusted locations via group
policies.
By the way, you really should not be using a beta version anymore for
development. The final version of Office 2007 has been available for
quite some time now.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


Hi All,

We have a toolbar developed in VBA which loads successfully whenever Word
and Excel(Office 2003) are started.

However when i tried it on Office 2007 Beta2 it's giving a securtiy warning
like Macro not certified. When i add the path from where it loads to Trusted
Location(Option,Trust Center,Trusted Location) i don't get the warning.

I would like to know how i can avoid this. Also i would be happy to know if
there is anything to automate these steps involved(i,e Option,Trust
Center,Trusted Location).

Regards,
Digambar.

Hi Patrick,

Thanks for your valuable advice.

In the beta version i had added the location path of the toolbar in the
trusted location (excel option, Trust Center,Trusted Location). Is it same as
what you r refering to as trusted locations via group policies.

If not please let me know how do i achieve the same.

Regards,
Digambar

Hi Patrick,

Is there way to Automate these steps Progrmmatically.

Thanks,
Digambar

 

[Digambar]

Thanks a lot for your valuable answers.

Then you have to get a digital certificate or explain to users in the
documentation how to deal with the issue. Although you might be able to
set the security settings by modifying the registry, you should not do
that for a variety of reasons. First of all, in the new Vista age, the
user might not have the necessary administrative privileges to alter
them. Secondly, those security settings protect the user from you. They
are the users to modify, not yours. Thirdly, if your add-in alters
security settings, corporate administrators will probably be reluctant
to trust your add-in and hence not allow their users to use it.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

No.Basically the add in can be used by anybody

Do you control these environments? Meaning, can you push out a group
policy setting to those users?

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


Most users are in Corporate Enivronment.

:

Are these users in a corporate environment or customers of a commercial
add-in?

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


Yes as a part of add -in. Because we don't want the user to do these
steps(Excel option,Trust Center, Trust Location).

If i can automate these steps during the loading the user can directly work
with the add in.

Regards,
Digambar.

:

You mean as part of your add-in?
No, those are security settings protecting the users from add-ins. Hence
why should you be able to modify them from your add-in?

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


:

It's the same.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


:

You would have to get a digital certificate to avoid this problem. Or,
if you are in a corporate scenario, set the trusted locations via group
policies.
By the way, you really should not be using a beta version anymore for
development. The final version of Office 2007 has been available for
quite some time now.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


Hi All,

We have a toolbar developed in VBA which loads successfully whenever Word
and Excel(Office 2003) are started.

However when i tried it on Office 2007 Beta2 it's giving a securtiy warning
like Macro not certified. When i add the path from where it loads to Trusted
Location(Option,Trust Center,Trusted Location) i don't get the warning.

I would like to know how i can avoid this. Also i would be happy to know if
there is anything to automate these steps involved(i,e Option,Trust
Center,Trusted Location).

Regards,
Digambar.

Hi Patrick,

Thanks for your valuable advice.

In the beta version i had added the location path of the toolbar in the
trusted location (excel option, Trust Center,Trusted Location). Is it same as
what you r refering to as trusted locations via group policies.

If not please let me know how do i achieve the same.

Regards,
Digambar

Hi Patrick,

Is there way to Automate these steps Progrmmatically.

Thanks,
Digambar