Menu Selection

Is it possible if when a menu item is selected another sheet is open .
What i am trying to do is when information is entered in a form and a menu value say NO is selected it then hides fields not required
hope its clear.


You could try conditional formatting, to hide/show/read fields when it meets the condition.

Ok that’s an idea.

Worked fine thanks

1 Like