Thanks! it worked but i found a different way id like to do it. I posted a
question called Simple Autofilter.

"Ewing25" wrote:

How do i get an input box to only come up once when the sheet is open?