Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Security
How can I set myself as a "Trusted source". I am helping an organisation
streamline there spreadsheet activities, this includes some macros. When I try to run a programme the security warning appears. Changing security level to Low and then resetting later is cumbersome. So I want to know how to identify myself as a Trusted Source so that the macros will be accepted |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Security
One option is to self sign the code and have them save that when they open
the workbook the first time. -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "Barry Lennox" wrote: How can I set myself as a "Trusted source". I am helping an organisation streamline there spreadsheet activities, this includes some macros. When I try to run a programme the security warning appears. Changing security level to Low and then resetting later is cumbersome. So I want to know how to identify myself as a Trusted Source so that the macros will be accepted |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Security
Thanks for the suggestion but what do I actually do. I play around on my home
computer then take it all to the other station on a flash drive. "Barb Reinhardt" wrote: One option is to self sign the code and have them save that when they open the workbook the first time. -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "Barry Lennox" wrote: How can I set myself as a "Trusted source". I am helping an organisation streamline there spreadsheet activities, this includes some macros. When I try to run a programme the security warning appears. Changing security level to Low and then resetting later is cumbersome. So I want to know how to identify myself as a Trusted Source so that the macros will be accepted |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Security
"Barry Lennox" wrote: Thanks for the suggestion but what do I actually do. I play around on my home computer then take it all to the other station on a flash drive. "Barb Reinhardt" wrote: One option is to self sign the code and have them save that when they open the workbook the first time. -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "Barry Lennox" wrote: How can I set myself as a "Trusted source". I am helping an organisation streamline there spreadsheet activities, this includes some macros. When I try to run a programme the security warning appears. Changing security level to Low and then resetting later is cumbersome. So I want to know how to identify myself as a Trusted Source so that the macros will be accepted |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Security
Barry,
Did you figure out "how" to do this? I have the same situation, i.e. creating spreadsheet tools with some macros for a client; work from home, copy onto their computer, etc. Can't believe that I can't create my own spreadsheet, and my own macro, and not have to "enable" the darn thing each time. And I don't want the client to have to do so (they won't remember how anyway...). And I don't want to change the security settings to low so that we're not protected from external macros. Thanks much, Leslie "Barry Lennox" wrote: Thanks for the suggestion but what do I actually do. I play around on my home computer then take it all to the other station on a flash drive. "Barb Reinhardt" wrote: One option is to self sign the code and have them save that when they open the workbook the first time. -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "Barry Lennox" wrote: How can I set myself as a "Trusted source". I am helping an organisation streamline there spreadsheet activities, this includes some macros. When I try to run a programme the security warning appears. Changing security level to Low and then resetting later is cumbersome. So I want to know how to identify myself as a Trusted Source so that the macros will be accepted |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Security
Hi Leslie
No I am sorry I just gave up as I only have one outside operation. If you have any success let me know. I have trouble logging in to this site. I select the option for the site to remember my name and password, but it only remembers my name and I still have to do everything twice. Barry "Leslie" wrote: Barry, Did you figure out "how" to do this? I have the same situation, i.e. creating spreadsheet tools with some macros for a client; work from home, copy onto their computer, etc. Can't believe that I can't create my own spreadsheet, and my own macro, and not have to "enable" the darn thing each time. And I don't want the client to have to do so (they won't remember how anyway...). And I don't want to change the security settings to low so that we're not protected from external macros. Thanks much, Leslie |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Security
Thanks Barry. I did find a possible solution that I just haven't tried yet.
I'm still on Excel 2002 here at home, and there isn't this issue with macro security, and haven't had time while at the clients office (who has Office 2007). In the Excel Programming discussion group, search for "selective macro security", and check out the reply from Gord Dibben. He seems to be very knowledgeable... I see his name all over the place posting back to all kinds of questions. Barb's reply to you initially referred to "self signing", but didn't give any details. That's was Gord has provided. Good luck. "Barry Lennox" wrote: Hi Leslie No I am sorry I just gave up as I only have one outside operation. If you have any success let me know. I have trouble logging in to this site. I select the option for the site to remember my name and password, but it only remembers my name and I still have to do everything twice. Barry "Leslie" wrote: Barry, Did you figure out "how" to do this? I have the same situation, i.e. creating spreadsheet tools with some macros for a client; work from home, copy onto their computer, etc. Can't believe that I can't create my own spreadsheet, and my own macro, and not have to "enable" the darn thing each time. And I don't want the client to have to do so (they won't remember how anyway...). And I don't want to change the security settings to low so that we're not protected from external macros. Thanks much, Leslie |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Security
Unfortunately self signed workbooks using the SelfCert tool will not
transfer to another computer. The certificate key cannot be exported. Gord Dibben MS Excel MVP On Wed, 1 Apr 2009 10:04:01 -0700, Leslie wrote: Thanks Barry. I did find a possible solution that I just haven't tried yet. I'm still on Excel 2002 here at home, and there isn't this issue with macro security, and haven't had time while at the clients office (who has Office 2007). In the Excel Programming discussion group, search for "selective macro security", and check out the reply from Gord Dibben. He seems to be very knowledgeable... I see his name all over the place posting back to all kinds of questions. Barb's reply to you initially referred to "self signing", but didn't give any details. That's was Gord has provided. Good luck. "Barry Lennox" wrote: Hi Leslie No I am sorry I just gave up as I only have one outside operation. If you have any success let me know. I have trouble logging in to this site. I select the option for the site to remember my name and password, but it only remembers my name and I still have to do everything twice. Barry "Leslie" wrote: Barry, Did you figure out "how" to do this? I have the same situation, i.e. creating spreadsheet tools with some macros for a client; work from home, copy onto their computer, etc. Can't believe that I can't create my own spreadsheet, and my own macro, and not have to "enable" the darn thing each time. And I don't want the client to have to do so (they won't remember how anyway...). And I don't want to change the security settings to low so that we're not protected from external macros. Thanks much, Leslie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro security | Excel Discussion (Misc queries) | |||
Macro Security? | Excel Discussion (Misc queries) | |||
Q About Macro Security | Excel Worksheet Functions | |||
Macro Security | Setting up and Configuration of Excel | |||
Security in macro | Excel Discussion (Misc queries) |