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
Thanks
hope its clear.

Hi,

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

Ok that’s an idea.
Thanks.

Worked fine thanks

1 Like