VB Save to Restricted File or Restricted Folder

[Muleskin57]

Hello Folks,
I've developed a workbook to be used by employees with access to a certain folder. At the end of the month, a macro is run to reformat for a new month. I'd like to save the completed file to a new filename (which can then be protected), or save the old filename to another file folder. Is there a way to get around the prompts when the macro runs?

Thanks,
Mule