Show sheet when userform is shown hide Sheet when userform is closed

I am trying to show sheet3 (named MCR (BLANK)) when ever the Userform1 is initialized and Hide the sheet when Userform1 is terminated.

Tried the code below, but it did nothing, any help or direction would be greatly appreciated.

Please Login or Register  to view this content.

Hello CtrlAltDelete,

I do not have Excel 2010, but please try the Workbook now. Instead of using the Userform Terminate Event, I have opted to disable the Close "X" Box on the Userform so that users are compelled to exit via the "Close" Button at the Bottom of the Userform.

Hope that helps.

Hi there,

Try modifying your code as indicated below:

Please Login or Register  to view this content.

Rather than deleting the lines you don't need, I've "commented them out" to make the changes a bit easier to see.

Hope this helps - please let me know how you get on.

Regards,

Greg M

P.S. Oops - got it the wrong way round! Just swap the "True" and "False" values for the Visible property to make it work the way you want it to

@ Greg M. Thank you that worked great. the code needed to be put in both the add item in the worksheet and the close button in the userform, thank you again! Posting the fixed sheet for anyone else having this issue in the future.

Hello CtrlAltDelete,

Thank you for the feedback. Yeah, it is hard to predict the interactions between different MS Office versions, whilst it runs perfectly on my side, same may not hold true with your set-up, it can turn out funny quirks. Glad I could help somewhat with the limited sesources at my disposal, and thank you for the "Rep" Tap.

'Till Later.

Appreciate that.