I have just installed Excel 2007. Each time I open a worksheet from Excel
2003, I have to enable my macros.

Can someone give me the steps for saving the macros as trusted source,
please?

My worksheets are stored on my main PC and I would like to use them from my
laptop.

Thanks.

Check out:-

Office Button

Excel Options (lower right hand corner)

Trust Center

Trust Center Settings . . .

If my comments have helped please hit Yes.

Thanks.











"abrielle" wrote:

I have just installed Excel 2007. Each time I open a worksheet from Excel
2003, I have to enable my macros.

Can someone give me the steps for saving the macros as trusted source,
please?

My worksheets are stored on my main PC and I would like to use them from my
laptop.

Thanks.

Just to add a little -- once you've clicked Trust Center Settings, then use
the 'Trusted Locations' group to manage (add/delete) new locations.

I wouldn't make any changes with the "Macro Settings" group - it sounds like
you already have them set right where I like mine to be: to alert me when a
workbook in a non-trusted location is opened that has macros in it and allow
me to decide if I want to permit them to run or not.


"trip_to_tokyo" wrote:

Check out:-

Office Button

Excel Options (lower right hand corner)

Trust Center

Trust Center Settings . . .

If my comments have helped please hit Yes.

Thanks.











"abrielle" wrote:

I have just installed Excel 2007. Each time I open a worksheet from Excel
2003, I have to enable my macros.

Can someone give me the steps for saving the macros as trusted source,
please?

My worksheets are stored on my main PC and I would like to use them from my
laptop.

Thanks.