I do not see what is going wrong here.
Before the user runs the macro, they are supposed to use the autofilter on the "Project" tab to determine which #'s they would like to sort the data by.
I have put a message box in, in case the user forgot to do that.
If they select "No", exit the sub and have the active sheet be the "Project" tab.
If "Yes" just run the macro(which works).
I cannot get the "Project" tab to be the sheet shown if "No" is clicked.
Any advice?
*edit: it always goes to the "SC" tab instead
Below is my macro:
Bookmarks