View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ErnDog ErnDog is offline
external usenet poster
 
Posts: 2
Default How do I copy worksheets with drop-down menus intact?

Yes, validation drop downs. I want to copy the worksheet to another
workbook. I'll try UR solution. Much thanks.

"Bob Umlas" wrote:

How are you copying the sheet? And dropdown menus are not part of a
worksheet anyway, they're part of the menuing system (commandbars). So,
assuming you're referring to data validation dropdowns or combobox
dropdowns, you need to copy the sheet with Edit/Move or copy sheet (or
ctrl-drag the sheet tab).
Copying cells won't do it.

"ErnDog" wrote in message
...
When I attempt to copy a worksheet with drop-down menus, the worksheet

copies
fine, but the drop-down menus to not copy at all.