Protected Sheet - Hide/Unhide Rows based on user input and other cell values

[rhynosaurus_rex]

Hi Everyone,

I have been able to find parts of the VBA for what I wouldlike to do, but not a solution that will work for my situation.

I have a password protected spreadsheet with a projectlist.
Projects are listed in Rows 10 – 200.

Column D contains project status (Open, Closed, Pending). Order of projects is random so Closed will bespread throughout the project list.

Unprotected Cell B2 is a user input in which the user canenter “Y” or “N” in order to show Closed Projects or not.

Y = Show Closed Projects
N = Hide Closed Projects

I would like to use a VBA to hide or unhide “Closed”projects based on the user input in Cell B2. This VBA will need to Unprotect and Protect the sheet after eachrun.

Is this possible? Thank you in advance!

 

[rhynosaurus_rex]

Hi again,

Any help would be appreciated. Thank you!