View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
juliejg1 juliejg1 is offline
external usenet poster
 
Posts: 81
Default Attaching Macros To Items In a List Box

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.