Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro security settings - digital certificates
Hi,
I have created series of models for use by a client, and they rely on an a macro to run as the files open to update the data. I do not wish to compromise their macro security and have discussed the possibilities of digital certificates. The files are to be stored on a shared drive and used by several differerent team members sat at different pcs. I know I can create a self-cert macro, but am I right in thinking that this can be used only on the pc it was created on? I have discussed them Microsoft Certificate Server, and they are unsure if they should have this as they are a Microsoft Partner. When I asked them about their partnership package, they said that they pay about £60k for the partnership and have the following documentation "3 action pack subscription toolkits A software cd 5 volumes of a technical demonstration toolkit And the fabric folder full of cds" That's all the information they could give me. My deadline for getting this system up and running is next Monday. I would be very grateful for any ideas or advice. Many thanks, Karen. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro security settings - digital certificates
I created a self-certificate in office and use that to digitally sign my
spreadsheets. Various users can have their Excel macro security set to High and have to open the spreadsheet twice. The first time you open the spreadsheet, you can View the certificate and then import it and tell Excel to trust it by placing it in the proper store. This will work and allow people to run the macros in your spreadsheet without dropping their security to medium or low. "KarenF" wrote: Hi, I have created series of models for use by a client, and they rely on an a macro to run as the files open to update the data. I do not wish to compromise their macro security and have discussed the possibilities of digital certificates. The files are to be stored on a shared drive and used by several differerent team members sat at different pcs. I know I can create a self-cert macro, but am I right in thinking that this can be used only on the pc it was created on? I have discussed them Microsoft Certificate Server, and they are unsure if they should have this as they are a Microsoft Partner. When I asked them about their partnership package, they said that they pay about £60k for the partnership and have the following documentation "3 action pack subscription toolkits A software cd 5 volumes of a technical demonstration toolkit And the fabric folder full of cds" That's all the information they could give me. My deadline for getting this system up and running is next Monday. I would be very grateful for any ideas or advice. Many thanks, Karen. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro security settings - digital certificates
Hi,
Thanks very much for that. Do they have to open it twice every time, or just until they import the trusted certificate? Thanks very much for your very prompt response. I can't wait to try it out. Take care, Karen "guillermo.ht" wrote: I created a self-certificate in office and use that to digitally sign my spreadsheets. Various users can have their Excel macro security set to High and have to open the spreadsheet twice. The first time you open the spreadsheet, you can View the certificate and then import it and tell Excel to trust it by placing it in the proper store. This will work and allow people to run the macros in your spreadsheet without dropping their security to medium or low. "KarenF" wrote: Hi, I have created series of models for use by a client, and they rely on an a macro to run as the files open to update the data. I do not wish to compromise their macro security and have discussed the possibilities of digital certificates. The files are to be stored on a shared drive and used by several differerent team members sat at different pcs. I know I can create a self-cert macro, but am I right in thinking that this can be used only on the pc it was created on? I have discussed them Microsoft Certificate Server, and they are unsure if they should have this as they are a Microsoft Partner. When I asked them about their partnership package, they said that they pay about £60k for the partnership and have the following documentation "3 action pack subscription toolkits A software cd 5 volumes of a technical demonstration toolkit And the fabric folder full of cds" That's all the information they could give me. My deadline for getting this system up and running is next Monday. I would be very grateful for any ideas or advice. Many thanks, Karen. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro security settings - digital certificates
After they "import" the certificate, the second time they open the
spreadsheet the enable macros and "always trust" options should be available. From that point they can open the spreadsheet and have the macros work everytime, the first time. "KarenF" wrote: Hi, Thanks very much for that. Do they have to open it twice every time, or just until they import the trusted certificate? Thanks very much for your very prompt response. I can't wait to try it out. Take care, Karen "guillermo.ht" wrote: I created a self-certificate in office and use that to digitally sign my spreadsheets. Various users can have their Excel macro security set to High and have to open the spreadsheet twice. The first time you open the spreadsheet, you can View the certificate and then import it and tell Excel to trust it by placing it in the proper store. This will work and allow people to run the macros in your spreadsheet without dropping their security to medium or low. "KarenF" wrote: Hi, I have created series of models for use by a client, and they rely on an a macro to run as the files open to update the data. I do not wish to compromise their macro security and have discussed the possibilities of digital certificates. The files are to be stored on a shared drive and used by several differerent team members sat at different pcs. I know I can create a self-cert macro, but am I right in thinking that this can be used only on the pc it was created on? I have discussed them Microsoft Certificate Server, and they are unsure if they should have this as they are a Microsoft Partner. When I asked them about their partnership package, they said that they pay about £60k for the partnership and have the following documentation "3 action pack subscription toolkits A software cd 5 volumes of a technical demonstration toolkit And the fabric folder full of cds" That's all the information they could give me. My deadline for getting this system up and running is next Monday. I would be very grateful for any ideas or advice. Many thanks, Karen. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro security settings - digital certificates
Thanks very much. That's really helpful.
Take care, Karen "guillermo.ht" wrote: After they "import" the certificate, the second time they open the spreadsheet the enable macros and "always trust" options should be available. From that point they can open the spreadsheet and have the macros work everytime, the first time. "KarenF" wrote: Hi, Thanks very much for that. Do they have to open it twice every time, or just until they import the trusted certificate? Thanks very much for your very prompt response. I can't wait to try it out. Take care, Karen "guillermo.ht" wrote: I created a self-certificate in office and use that to digitally sign my spreadsheets. Various users can have their Excel macro security set to High and have to open the spreadsheet twice. The first time you open the spreadsheet, you can View the certificate and then import it and tell Excel to trust it by placing it in the proper store. This will work and allow people to run the macros in your spreadsheet without dropping their security to medium or low. "KarenF" wrote: Hi, I have created series of models for use by a client, and they rely on an a macro to run as the files open to update the data. I do not wish to compromise their macro security and have discussed the possibilities of digital certificates. The files are to be stored on a shared drive and used by several differerent team members sat at different pcs. I know I can create a self-cert macro, but am I right in thinking that this can be used only on the pc it was created on? I have discussed them Microsoft Certificate Server, and they are unsure if they should have this as they are a Microsoft Partner. When I asked them about their partnership package, they said that they pay about £60k for the partnership and have the following documentation "3 action pack subscription toolkits A software cd 5 volumes of a technical demonstration toolkit And the fabric folder full of cds" That's all the information they could give me. My deadline for getting this system up and running is next Monday. I would be very grateful for any ideas or advice. Many thanks, Karen. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Digital certificates | Excel Discussion (Misc queries) | |||
Delete Digital Certificates | Excel Programming | |||
Digital Certificates and other users | Excel Programming | |||
Digital Certificates | Excel Programming | |||
Removing Digital Certificates | Excel Programming |