VBA to hide userform and make worksheet active

Hi,

Please can someone help me?

I have a userform I'd like to hide and the speadsheet becomes active when the command button is pressed.

Also I have a code that fades out the speadsheet while the userform is active.

I've attached my file and in the userform (Search) I have added the "VIEW SPREADSHEET" button but at the moment it only hides the userform for 10 seconds and the speadsheet is still dark from the fading code.

Any help would be much appreciated.

Kind Regards

Dan

I'm not sure what help you're actually asking for here.

The reason the UserForm only hides for 10 seconds is your code tells it to do so in this line:

Please Login or Register  to view this content.

You'll need to give us more details if you need more help.

BSB

Hi BSB,

To be honest, after thinking about it some more yesterday I've decided to abandon this option altogether. I think I was massively over complicating the situation.

Thank you for taking the time to look at it and reply and I am sorry to mess you about.

Kind regards

Dan