Filter not displaying info after hiding worksheet

[alwayslrN]

Hello.

I am using Excel 2002. I have a worksheet that acts like a database, a worksheet that displays information from the previously mentioned worksheet based on filters. The filters are three comboboxes. I also have a worksheet that holds the list of data to populat each of the three comboboxes. I am using the Visible property for the first and last worksheets.

The problem I am having however, by hiding the database worksheet is that when I make my selections from the comboboxes no information displays. Do I have to add code to hide and unhide the database sheet? I tried looking through previous posts to find the solution, but I am not using the correct keywords, apparently.

 

[Fenrirshowl]

I think you do have to unhide the worksheet as I expect the filters are working via a selection of some sort (- anyone out there can correct me if I'm wrong).

If so, add a few quick lines to unhide and rehide your data and make use of the Application.ScreenUpdating property (=False/True) before and after, to prevent the user from seeing what's going on.

Fen

 

[CBasicAsslember]

Do I have to add code to hide and unhide the database sheet?

You should not have to. The code that gets the data from the hidden sheet would be helpful.