The reason I suggest putting the listbox on the UserForm instead of the sheet
is that when you hide the sheet with the listbox on it, you have no way to
change the selection. The listbox is also hidden. With the listbox on a
UserForm, it can be called for any sheet. You might want to set up a butoon
or keyboard shortcut to run the macro that calls the userform, otherwise you
will have to call it from the ToolsMacromacro.

"juliejg1" wrote:

I have a list box ListBox1 on a worksheet called Data. The list box fill
range is List!A1:A12 where I have a list of months. I have 12 worksheets
with each month for the worksheet name. When a user selects a month from the
list box I would like to call the corresponding worksheet and hide the other
eleven. Is there an easy way to do this. I am not experienced with writing
macros...only recording them.