move/copy lost format in destination workbook

A

AGould7

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.
 
Top