Form Tools appear on new page

[virgilio]

I'm writing a script that filters on a name and writes the entire row containing that name on a new sheet. It works fine except that the form controls that I used appear on the new page with invalid values.

How do I hide these unwanted form controls?

Here's my code, I Dim'd "taskOwner" at the top of the page as a string and it is set by a combo-box in a different Sub:

Please Login or Register  to view this content.

[Greg M]

Hi there,

See if the highlighted additions do what you need:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[virgilio]

Thank you, it seems to work!

It was still there from a previous run and I had to delete it manually at first, but it didn't reappear after the addition.

[Greg M]

Hi again,

Many thanks for your very prompt feedback.

You're welcome - glad I was able to help.

Regards,

Greg M