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.

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.

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.

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.

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.