I set up a macro in a users excel, which works great for the user, however there is a problem this user is experiencing: when ever the user opens up any spreadsheet she has to either click on enable or disable macros. i had to set the marco up so that the macro will be there for when she imports a report from crystal reports however she does not need the marcos for any other spreadsheet. is there a way that i can set up the macro so that she does not have to click on disable for all of her other spreadsheets but the macros be there for when she imports a report into excel? -- Thank you,
First off this is a newsgroup for MS Access the database program so you would be better off posting this question in an excel group. Also folks will need to know what version of excel you are using to answer this question. If 2007 add the locatation of the file to the trusted location under excel options, trust center. If it is an older version you will have to sign the vb code as trusted publisher or lower security. "luv2bike2" wrote in message news:BDEBD974-74D8-45F8-A437-1F6F000E3635@microsoft.com... >I set up a macro in a users excel, which works great for the user, however > there is a problem this user is experiencing: > > when ever the user opens up any spreadsheet she has to either click on > enable or disable macros. i had to set the marco up so that the macro > will > be there for when she imports a report from crystal reports however she > does > not need the marcos for any other spreadsheet. is there a way that i can > set > up the macro so that she does not have to click on disable for all of her > other spreadsheets but the macros be there for when she imports a report > into > excel? > > > -- > Thank you, >
thank you for getting back to me on this. i am sorry, I thought i was in the Excel forum. I will repost it in the Excel forum with the version. Thanks again. "Pete D." wrote: > First off this is a newsgroup for MS Access the database program so you > would be better off posting this question in an excel group. Also folks > will need to know what version of excel you are using to answer this > question. If 2007 add the locatation of the file to the trusted location > under excel options, trust center. If it is an older version you will have > to sign the vb code as trusted publisher or lower security. > "luv2bike2" wrote in message > news:BDEBD974-74D8-45F8-A437-1F6F000E3635@microsoft.com... > >I set up a macro in a users excel, which works great for the user, however > > there is a problem this user is experiencing: > > > > when ever the user opens up any spreadsheet she has to either click on > > enable or disable macros. i had to set the marco up so that the macro > > will > > be there for when she imports a report from crystal reports however she > > does > > not need the marcos for any other spreadsheet. is there a way that i can > > set > > up the macro so that she does not have to click on disable for all of her > > other spreadsheets but the macros be there for when she imports a report > > into > > excel? > > > > > > -- > > Thank you, > > > > >
