hide & unhide multiple sheets based on cell value

[tubrak]

hi experts
my real file contains sheets are about 50 sheets, but I attach simple file contains two sheets to understand my idea. so what i want when write the value in B2 in sheet MAIN should match for all hidden sheets with cell M28 if it's match for one of them then should show that's sheet which contain right value if not then stay hidden and if I select another sheet to search for
it . it should hidden the sheet has ever searched whether when search for a new sheet if the value is matched or not .
thanks .

[6StringJazzer]

Put this code into the module for worksheet main. Do not use the code you have in Module1.

Please Login or Register  to view this content.

Also, I strongly recommend to everyone that they use Option Explicit and declare variables. Doing so prevents a lot of bugs and runtime errors.

[tubrak]

thanks . but I would understand this Me.Name what means especially Me ,please?

[6StringJazzer]

Whenever you use Me it refers to the object that owns the code module. In this case it is the worksheet. So Me.Name = "main". We use Me.Name so that if someone changes the name of the worksheet on the tab, the code will not have to be changed.

[tubrak]

n this case it is the worksheet. So Me.Name = "main".

I suspect that , but I was needing confirmation from you.
thanks so much for your solution .