I currently have a command button that will copy and export the active worksheet to a new file with a specific naming convention for saving. However, I want the same button which appears in the new file to be repurposed when that file is opened. Is there a way to make either a new button appear in this instance based on the different file name or to have this one change purpose after having run once?
Bookmarks