Unhide sheet and make active on cell value

I have a workbook with 2 sheets, Problem and Solution. The Solution sheet is hidden. When the correct value is entered in C5 of the Problem sheet I would like the Solution sheet unhidden and made active.

Thank you for responses

Hi Shooter490,

Welcome to the forum!!

Try this event macro on the Problem tab:

Please Login or Register  to view this content.

Note, to attach this code to the Problem tab follow these four steps:

1. Copy my code above to the clipboard (Ctrl + C)
2. Right click on the Problem tab name and from the shortcut menu select View Code
3. Paste (Ctrl + V) my code from the clipboard (step 1) into the module
4. From the File menu select on Close and Return to Microsoft Excel (Alt + Q)

Regards,

Robert

Glad to hear it

Please don't forget to mark the thread as solved when you get a chance.

Robert