Need to better VBA code.

[hecgroups]

Hello Again,

Can any one help to write below code in better way. This is the part of my code. What i am doing here is i am creating a new sheet with below mentioned names and hiding it. If user click to view user form based on below mentioned sheets name the form control will be visible.

What i want here is if the below sheets exists and visible then only user form (Generate) will be shown or it will give message as mentioned below in a code.

Please Login or Register  to view this content.

[p24leclerc]

Is this close to what you are looking for?

Please Login or Register  to view this content.

I might have misinterpreted your saying though.

[hecgroups]

Thanks for your response. I will provide you feedback.