Muleskin57
New Member
- Joined
- Dec 22, 2016
- Messages
- 23
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
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