Quick activate sheet programming question

[phpolicylady]

I have the following macro set to verify if a user has selected "Yes" in five different cells on the Sheet named "Home". It checks each and if any are not equal to "Yes" it returns the message "Nope". It then takes the user back to the Home sheet so they can enter the data required.

Please Login or Register  to view this content.

I don't know how to allow the user to go to any selected sheet other than the one I specify in the final Else: statement. I want them to go to whichever sheet they originally selected if they have entered all the required data.

I'm sure it's some cool thing like Sheets("whatevertheuserjustclicked").Select...but I don't know! Thanks!

[nigelbloomy]

Does this work?

Please Login or Register  to view this content.

[phpolicylady]

Yes - Perfectly!!!!

Thanks so much!

[nigelbloomy]

You are welcome. Thanks for the rep too.