The spreadsheet is a checklist.
The users answer to each question by "Yes" or "No" (via a drop down)
Before that, another code establishes which user profile is applicable ("A", "B" or "C") and hides other rows (that are by default not applicable to the concerned profile)
This code below should hide or show rows depending on the answer to specific questions.
and if the user profile is "B" (Sheet5.Cells(8, 10).Value = "B") , the three last IF statements statements should not be checked (because the profile code directly hides the corresponding rows)
If profile is not "B" then all statements should be checked.
I tried this but it doesn't work:
if 'profile is "B" then
stop
end if
thank you for any help.
![]()
Please Login or Register to view this content.
Bookmarks