Please post your code and specify where the error is, it helps to diagnos the
problem. Otherwise we are just guessing what you need.

--
Cheers,
Ryan


"Dolores" wrote:

I need to create a macro to save an excel file in a separate directory.
However I am not that familiar with creating macros (i'm much better at
making changes to an existing macro).

The problem that I am running into is that the file that is saved in the
other directory is a protected excel spreadsheet, so when I run my macro it
gives me an error.