Marcos in Excel

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:
>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,
>