Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Certifying Macros in a Domain
Hello friends. I have an internal Excel spreadsheet that I
designed and that is soon to be used by many company associates when it is released. The question I have is this: How do I design the spreadsheet so that all users that access the .xls file automatically download the included macro without getting the security prompt? Touching each machine to lower the security settings would be too much work. I've heard there is a way to do this at the original file or domain level, removing the prompt and installing the macro without question. Thanks to all for any assistance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Certifying Macros in a Domain
That's the whole point of having security - to STOP
people uploading code that could be a virus. -----Original Message----- Hello friends. I have an internal Excel spreadsheet that I designed and that is soon to be used by many company associates when it is released. The question I have is this: How do I design the spreadsheet so that all users that access the .xls file automatically download the included macro without getting the security prompt? Touching each machine to lower the security settings would be too much work. I've heard there is a way to do this at the original file or domain level, removing the prompt and installing the macro without question. Thanks to all for any assistance. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Certifying Macros in a Domain
Would anyone with some actual Excel experience care to
comment? There is a way to CERTIFY a specific macro INTERNALLY so associates don't have to see the security prompt, I just don't know how to do it. Has anyone done this? -----Original Message----- That's the whole point of having security - to STOP people uploading code that could be a virus. -----Original Message----- Hello friends. I have an internal Excel spreadsheet that I designed and that is soon to be used by many company associates when it is released. The question I have is this: How do I design the spreadsheet so that all users that access the .xls file automatically download the included macro without getting the security prompt? Touching each machine to lower the security settings would be too much work. I've heard there is a way to do this at the original file or domain level, removing the prompt and installing the macro without question. Thanks to all for any assistance. . . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Certifying Macros in a Domain
I've never used it, but you could search google for references to SelfCert.
Availability depends on your version of excel. Tom wrote: Would anyone with some actual Excel experience care to comment? There is a way to CERTIFY a specific macro INTERNALLY so associates don't have to see the security prompt, I just don't know how to do it. Has anyone done this? -----Original Message----- That's the whole point of having security - to STOP people uploading code that could be a virus. -----Original Message----- Hello friends. I have an internal Excel spreadsheet that I designed and that is soon to be used by many company associates when it is released. The question I have is this: How do I design the spreadsheet so that all users that access the .xls file automatically download the included macro without getting the security prompt? Touching each machine to lower the security settings would be too much work. I've heard there is a way to do this at the original file or domain level, removing the prompt and installing the macro without question. Thanks to all for any assistance. . . -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Certifying Macros in a Domain
Tom
KB Article on certificates, including SelfCert. http://support.microsoft.com/default...b;en-us;288985 After you get the certificate created you will check its properties. It will be "untrusted". To make it into a Trusted Certificate you must open the Microsoft Management Console(Windows XP) by StartRun "mmc"(no quotes). FileAdd/Remove Snap-inCertificates. Your new certificate will be under the Personal category. Drag and drop it into the Trusted Certificates category. These selfcerts are machine-specific but can be used for multiple files. I am not sure what steps to take on a multi-machine domain. Give it a try. You never know your luck<g OR.........You could buy one from Verisign or Thawte. Gord Dibben Excel MVP On Wed, 21 Apr 2004 20:38:07 -0500, Dave Peterson wrote: I've never used it, but you could search google for references to SelfCert. Availability depends on your version of excel. Tom wrote: Would anyone with some actual Excel experience care to comment? There is a way to CERTIFY a specific macro INTERNALLY so associates don't have to see the security prompt, I just don't know how to do it. Has anyone done this? -----Original Message----- That's the whole point of having security - to STOP people uploading code that could be a virus. -----Original Message----- Hello friends. I have an internal Excel spreadsheet that I designed and that is soon to be used by many company associates when it is released. The question I have is this: How do I design the spreadsheet so that all users that access the .xls file automatically download the included macro without getting the security prompt? Touching each machine to lower the security settings would be too much work. I've heard there is a way to do this at the original file or domain level, removing the prompt and installing the macro without question. Thanks to all for any assistance. . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can this be done with Domain Functions? | Excel Worksheet Functions | |||
NT Domain Users | Excel Programming | |||
NT Domain Logon | Excel Programming |