Sorting and Filtering Data in Hidden Worksheets

[SpikeGiles]

I have a workbook that has several sheets of sensitive data. I have several reports and charts built off of these data that are run by VBA code. I want to hide the actual sensitive data sheets, but when I do that I get error codes when I try to run the filtering code. Is there a way around this problem?

 

[JoeMo]

One way would be to add Application.ScreenUpdating = False to your code. Then have the code unhide the sheets, do the filtering and then hide the sheets again.