Disable Auto-Refresh Autofilter, update on button click

[alfordtp]

I have a large table that I want customers to only see the information after they make selections from the autofilter options.

Is there a way to disable the automatic refresh option and only refresh the autofiltered data after a button is clicked?

I want to do this in VBA along with locking the zoom and scrolling to only allow them to see what was selected.

Any help would be appreciated. Thanks.

Tim