VBA Sub private hide all sheet except one

[julielara]

Hi experts

I need help on sub worksheet_click function, i want hide all sheet when active Main sheet

i have list of 20 sheet it takes alot of time to close i want hide all sub sheet except main sheet when i come select or click main sheet

i want only worksheet_click private function,

find the attachment.

[julielara]

any expert help on this?

[jindon]

1) to ThisWorkbook code module

Please Login or Register  to view this content.

2) to Main sheet code module

Please Login or Register  to view this content.

[julielara]

Thanks for solved i have small issue i have userform with listbox listing sheet names, and i do select and click cmd, to open sheet but it would nt work after i install this code any solution to solve this

[jolivanes]

It might help if you show ALL the code.

[jindon]

it would nt work after i install this code any solution to solve this

Of course, you are now asking completely difference question.

Upload your workbook with the user form, and explain what do you want to happen when you do what action.

[breadwinner]

Hi expert pls find the attachment, i added your code in wb

thanks

[AliGW]

@Breadwinner - why do you have two user accounts?

[jolivanes]

In the "UserForm_Initialize" you only need the hidden sheets. "Main" sheet is visisble so does not need to be in the list.
Add this line before the "Sheet.Activate" line

Please Login or Register  to view this content.

[jindon]

julielara or breadwinner,

You are not answering to my post #6.

Only my guess
Delete all the codes I posted in #3.

Please Login or Register  to view this content.

[julielara]

Its my hubby account we use same laptop i think its synchronic his threat to my acc while auto fill login

[jolivanes]

Does your hubby approve of the suggestions?

[breadwinner]

Perfect thanks

[julielara]

its works perfectly thanks for your valuable time, Thanks alot experts solved!!

[julielara]

@breadwinner come on mate dont msg on my thread please