I've fixed the Error and have gotten the "ADD SHEET" portion of the code to work.
I tired using Workbook_BeforeSave but I wasn't sure how to code it.
I then tried Workbook_Deactivate, but it kept deleting the "INGREDIENTS" sheet.
I'm at a loss on how to work around this.
Any ideas?
There is an updated version of the file attached.
Bookmarks