Display Hidden Sheet(s) based on cell value

Hello & thank you for this forum.
I have a workbook that contains multiple worksheets. I have an overview form which displays specific data concerning parts. Some parts need to be documented via "form1" (sheet2) & some parts need to be documented by "form2" (sheets 3 & 4). I have added a document via field to display which form should be used & would like to incorporate some code that would hide all sheets except for the sheets corresponding to the apropriate form. My overview form uses vlookup. My workbook is password protected to preclude users from altering master data or formulas. Thanks in advance for your expertise.

use visible command to hide or display sheets

Sheets("Sheet1").Visible = False ' hide
Sheets("Sheet1").Visible = True ' display

use visible command to hide or display sheets

Sheets("Sheet1").Visible = False ' hide
Sheets("Sheet1").Visible = True ' display

Welcome to the forum.

Normally, I set worksheet protection in the Open event of the ThisWorkbook object.

Change the password "ken" and the sheets to leave visible to suit.

Please Login or Register  to view this content.

Olly,

This worked like a champ! Thank you. Sorry it took so long to respond. Thought I had responded immediately. Thanks again.