Using Userform to Hide/Show specific Sheets in Work Book

[Craigs]

Hi,
I am trying to use a userform to select and show sheets in a workbook where the default is for all sheets to be hidden.
Basically when the user selects a sheet name from the combobox on the userform I need that sheet to bcome active and the previous sheet to becom hidden.
I would also like 1 other sheet to be permanantley visible.

I have come up with the code below which works to a certain degree, it allows me to do 90% of what I require however if the user were to select the active sheet name from the comboxbox when it is already open the macro locks up.

Please Login or Register  to view this content.

End Sub



Any ideas how I can overcome this?

Thanks

[royUK]

See this SheetsToHide.zip

[Craigs]

Hi Roy.

Thanks for looking at my post, I have tried clicking on your ling but it doesnt seem to work.

[royUK]

Sorry, I've corrected the link