When I move/copy a worksheet with drop down lists. It loses its formating in
the destination workbook. the sheet I'm coping is locked so I can't use
copy/paste special. any thoughts on how to preserve the formating and macros
during the copy process.