How do I copy worksheets with drop-down menus intact?

G

Guest

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

Bob Umlas

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

Bob Umlas

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

Guest

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

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modifying Data in Drop Down Menu 2
Restrict Choice in Shared WB (drop down alternative)? 0
How do I link 2 data sets to 2 drop down menus? 2
Auto fill Cells with text 2
Drop Down with dynamic named range offsheet source list 14
Date Range Drop Down Menu 1
drop down menus and corresponding hyperlinks 1
Sum from a Drop down menu using value in the cell below 11

Top