Worksheet does not become the active 1 using .Activate function based on MsgBox response

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:

Please Login or Register  to view this content.

If the tab 'Project' is hidden, then you need to add:

Please Login or Register  to view this content.

before Activating it.

It is not hidden.

I would say it's because Response is declared as Boolean and thus can only have two values: True or False, so it won't accept vbNo. Change Response variable to be as String and it should work. But this is only my opinion

Sbarro79, thank you very much! works like a charm

Also, Change:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

Some words do not work effectively when declared, and try Variant instead of Boolean.