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.