Hello,

I've look through the newgroup and I did not find what I was looking
for I need help modifing my code. I have 28 worksheets in one workbook:


The names are Main, Settings_North, Settings_South, Settings_MainList,
Reserve, January 2006 NORTH, February 2006 NORTH, March 2006 NORTH,
April 2006 NORTH, May 2006 NORTH, June 2006 NORTH, July 2006 NORTH,
August 2006 NORTH, September 2006 NORTH, October 2006 NORTH,November
2006 NORTH, December 2006 NORTH, January 2006 SOUTH, February 2006
SOUTH, March 2006 SOUTH, April 2006 SOUTH, May 2006 SOUTH, June 2006
SOUTH, July 2006 SOUTH, August 2006 SOUTH, September 2006 SOUTH,
October 2006 SOUTH, November 2006 SOUTH, December 2006 SOUTH

The Main Worksheet will have my dropdown and Settings_MainList will
have my worksheet name list.

This is what I'm tring to do when I click a worksheet name from my
dropdown I would like to be able to select "Print North" or "Print
South". Then I get to select either North Months or South Months and it
presents a message that says "You are printing January 2006 NORTH
worksheet!" or the month that applies and when they click ok button it
will print the worksheet.

This is the code I have so for:

Sub Control_Dropdown()


'Sheets("Settings_MainList").Select
MsgBox "Would you like to Print January 2006 worksheet now?"
Sheets("January 2006 NORTH").Range("A1").PrintPreview
End

MsgBox "Would you like to Print Feburary 2006 worksheet now?"
Sheets("Feburary 2006 NORTH").Range("A2").PrintPreview
End

MsgBox "Would you like to Print March 2006 worksheet now?"
Sheets("March 2006 NORTH").Range("A3").PrintPreview
End

MsgBox "Would you like to Print April 2006 worksheet now?"
Sheets("April 2006 NORTH").Range("A4").PrintPreview
End

End Sub

Thank you for your help,
James Cooper