I have a workbook with some code inside of it. When I turn off
Autofilter after using the buttons in the top left of the sheet to
filter by cell color all of the text fields on the entire sheet are
moving to A1 on top of each other. I have no idea why this is
happening nor is it throwing an error. I uploaded the sheet here
www.justinvalinski.com/newTest.xlsm for further review. I tried
uploading on this site but the file is too large to upload. This one
is just perplexing so any advice or if you know of a fix PLEASE let
me know as I've been staring this one down for quite some time now.

Yep, that's what happens when you use controls on a worksheet. I
stopped doing that long time ago. Instead of using controls I use
actual cells, and just make them look/feel/behave like controls so they
ALWAYS stay put (even if they're in scrollable/hidden sections of a
worksheet). I use the Worksheet_SelectionChange or Worksheet_Change
events, depending on the type of control being imitated, for executing
code.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion