Marcos in Excel

[luv2bike2]

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?

 

[Pete D.]

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]

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.

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.