I am trying to begin a macro that will do a lot of things, for now it will just copy paste a worksheet from an unopened workbook to be pasted into a new worksheet in the current workbook called Temp. I tried it once and it worked up until the point of copying the source worksheet, then stopped. I assumed it was stopped by me clicking on a dialog asking to update or not and tried disabling Alert Displays. Now absolutely nothing is happening when I choose something from the drop down. Anyone know what's going on?
Bookmarks