Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

macro security settings

  
   Windows Help (Home) -> Microsoft Excel RSS
Next:  I think I'm infected  
Author Message
chriske911

External


Since: Jan 28, 2009
Posts: 2



(Msg. 1) Posted: Wed Jan 28, 2009 10:25 am
Post subject: macro security settings
Archived from groups: microsoft>public>excel (more info?)
I would like a way to set macro security thru GPO for Excel 2007 SP1 to
allow only macro from the startup folder and not from any other files

this is actually a group policy question but as this is rather excel
specific I was hoping to find the answer here.

thnx

 >> Stay informed about: macro security settings 
Back to top
Login to vote
Shane Devenshire

External


Since: Nov 13, 2008
Posts: 17



(Msg. 2) Posted: Wed Jan 28, 2009 10:25 am
Post subject: RE: macro security settings
Archived from groups: per prev. post (more info?)
Hi,

Assuming you mean by startup folder a specific folder then choose, Office
Button, Excel Options, Trust Center, Trust Center Settings, Trusted
Locations...

 >> Stay informed about: macro security settings 
Back to top
Login to vote
chriske911

External


Since: Jan 28, 2009
Posts: 2



(Msg. 3) Posted: Thu Jan 29, 2009 5:25 am
Post subject: Re: macro security settings
Archived from groups: per prev. post (more info?)
Shane Devenshire explained on 28/01/2009 :
> Hi,

> Assuming you mean by startup folder a specific folder then choose, Office
> Button, Excel Options, Trust Center, Trust Center Settings, Trusted
> Locations...
> --
> If this helps, please click the Yes button

> Cheers,
> Shane Devenshire


> "chriske911" wrote:

>> I would like a way to set macro security thru GPO for Excel 2007 SP1 to
>> allow only macro from the startup folder and not from any other files
>>
>> this is actually a group policy question but as this is rather excel
>> specific I was hoping to find the answer here.
>>
>> thnx
>>
>>
>>

by startup folder I mean the personal.xls in the application data
folder of the user
so I only want to enable the macro's that are in the personal.xls or
it's excel 2007 equivalent
I do not want any other trusted location, not even on our own network
or thru outlook/internet explorer

grtz
 >> Stay informed about: macro security settings 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Macro for 'Paste Special' - Is there a way to set a macro up so that perform a 'paste special' into whatever cell is currently highlited? Thanks in advance.

Excel Macro Problem - I have a database with 98 sheets. One sheet for each bus in our fleet. I need to updated the links for each sheet from xls to xlsm without changing the bus number in the link. I used to be able to create a macro to make a change in a few sheets in....

Macro takes forever - didn't used to - Hi, I'm running a macro to rearrange some tables and add alternate row colors. In the past this macro only took about 15 seconds to run and now it takes several minutes. I can't recall installing any new apps besides windows updates in a long time. I...

copy/paste macro - I am trying to create a macro that will copy a range of data; however, the number of rows to copy will vary each time the macro is run. Is there a way that I could creat parameter fields that the macro cuold read? Thanks, Micki

Macro for listing sheet names - I have this macro (inherited from another user) that will take all the sheet names and put it in a list. My problem is it lists the last sheet first. I need it skip the first sheet which is my master list and then starting with the next sheet put..
   Windows Help (Home) -> Microsoft Excel All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]