ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   A question about Trusted Publishers... (https://www.excelbanter.com/excel-programming/394018-question-about-trusted-publishers.html)

IT_roofer

A question about Trusted Publishers...
 
I'm creating an Excel add-in for my company and I was getting tired of
clicking "Enable Macos" every time I opened up my project so I did a little
looking around and found info on this: VBE Tools Digital Signature... So
I went in and it allowed me to use my own credentials (Company Name\User
Name) to sign the macros. I saved and closed Excel; then reopened it. When I
did, I was greeted with a different typeof macro security prompt about an
"untrusted publisher" (listed my username) and, at the bottom, was a checkbox
for "always trust this publisher". SO naturally, I checked the box, saved and
closed Excel. When I reopened my project, I didn't get the macro security
prompt and the project loaded fine. So here's the question: is my project
going to work on other employee's machines? Will they get the same "trusted
publisher" prompt or will it just load like it did for me?

CoRrRan

A question about Trusted Publishers...
 
IT_roofer wrote:
I'm creating an Excel add-in for my company and I was getting tired of
clicking "Enable Macos" every time I opened up my project so I did a little
looking around and found info on this: VBE Tools Digital Signature... So
I went in and it allowed me to use my own credentials (Company Name\User
Name) to sign the macros. I saved and closed Excel; then reopened it. When I
did, I was greeted with a different typeof macro security prompt about an
"untrusted publisher" (listed my username) and, at the bottom, was a checkbox
for "always trust this publisher". SO naturally, I checked the box, saved and
closed Excel. When I reopened my project, I didn't get the macro security
prompt and the project loaded fine. So here's the question: is my project
going to work on other employee's machines? Will they get the same "trusted
publisher" prompt or will it just load like it did for me?


You'll find the following article quite interesting:
http://msdn2.microsoft.com/en-us/lib...ffice.11).aspx

CoRrRan


All times are GMT +1. The time now is 06:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com